Paste clipboard values into shet

[tomleitch]

Hi,

I have a userform which is being used to import data (that has been copied onto the clipboard from another sheet).

I want to make the userform paste it in - but the range of it may be variable.

Is there any way to do this paste operation by only specifying the starting cell (A1)?

Similar to how you would click it and paste normally and it would automatically set the paste range?


Thanks
Tom

 

[shg]

Range("A1").PasteSpecial

 

[tomleitch]

Well that was easier than I expected! Cheers shg