Hi Jeff,
Assuming that every cell you copy from Excel contains only a single line of text with no line breaks (otherwise the lines collection in For Each won't give you the results you want, since it will be pasting multiple lines from a single cell rather than all of the text contained in a single cell), the only major change I can see that you need to make to your macro is to replace the "custom paste with clipboard cleaning" action with an action that pastes the SingleLine variable you specified at the top of the For Each action, like this:
If you have any other actions that you're using right now to clean up the clipboard with every paste, you'll want to make sure those are added too so that the cleanup happens with every line pasted. If you have any further questions, feel free to ask; I know I certainly found For Each to have a steeper learning curve than many other KM actions 