Excel VBA copy and paste a defined selected range

[Sam1989]

Hi all, I'm trying to write a vba code to allow the user to select multiple cells (scenario column numbers I later intend to use with "OFFSET" function to run analysis) and paste those cell values in other sheet.

So far this is what I have:

Now all I'm intending to do is to paste the results of "z.Address" in "results" sheet lets say in a defined row 22.

I've tried bunch of paste syntax I found but I always get compile error before running it.

I appreciate your help with this!

[Fluff13]

Maybe

Please Login or Register  to view this content.

[Sam1989]

This is awesome! Thanks!

[Fluff13]

You're welcome & thanks for the feedback