SUBJECT: Error handler if copy area different from paste area.

I am writing a macro that pastes cells from the clipboard to a spreadsheet.
But I want the macro to run ONLY if the number of columns already on the
clipboard is EXACTLY the same as a number that I plan to specify in code.

In other words, I need some way of determining how many columns are on the
clipboard BEFORE I commit to the paste operation.

If the number of columns that are about to be pasted is not what I expect,
then I will write an error handler to abort the paste operation.

So, my question is - - -

How can I tell how many columns will be pasted BEFORE I commit to the paste
operation?

Paul S. Natanson +1-908-630-0406 paul628 at concentric dot net
December 1, 2006