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