Pasting range from clipboard

Hi all,

This seems really simple but I've spent hours searching the forums without success. I'm writing a subroutine where the user copies data (multiple rows and columns of values) to the clipboard (control c) from another Excel document and then presses a form control button. This starts a macro, which begins by pasting the data in to a blank sheet. I cannot get this to work.

Pasting the data manually (control V) to cell A1 on the sheet works fine, but just copying what the macro recorder shows (see below) yields the error 'Paste method of Worksheet class has failed'. I've tried too many codes to display them all here, but surely this is simple?

Please Login or Register  to view this content.

Many thanks for your help!
Matt

The source document always has a different filename, and the range is always different. It's easy for the user to copy it to clipboard but a macro finding the desired range would be complicated (especially as the source document could change formatting)

Thanks patel,

Unfortunately I get a 'Get text invalid format structure' error on the line S = DataObj.GetText. I should note that my data is all numbers,

Thanks a lot Patel, that works! I've just got to try and understand why now.