Re: vba macro: I'm losing 'end of row' lin cut/pasting multiple (non-adjacent) rows
Not sure why I can't get InsertClipboardUnderSelectedRow macro above to work once I have row data on my clipboard using your SelectionToClipboard
I got this to work, just can't INSERT, only paste or over-write data.
This does allow me to call FormatClipboardPaste and get that done at the same time, so I don't forget. (but still having that issue I mentioned, scenarios where I paste only column A, see below)
Even when using FormatClipboardPaste, there are still several scenarios where your SelectionToClipboard still pastes ONLY data in column A for all the rows.
i.e. SelectionToClipboard from source file to new workbook, run FormatClipboardPaste, then highlight any number of rows and paste back to original source worksheet and only the data from column A pastes. Data from column B through Q or whatever is gone.
Anyway, if you have a little more time some point. I'd love to get a couple last things worked out.