Putting some range of same cells to variable

Help me please,
how I can to put some range of cells from one sheet into toh variable in macro for reading them and put them on another sheet ?

I have a macro to create more than one pivot table, but using the same range of cells which are on another sheet.
Thank You
Radovan Zigraj:eek2:

Post your code.

I think if its just a range, and you are getting it via the .address property, you just need to change the sheet reference...


Vince