Pivot tables and macros
 

i currently use macros to change some downloaded sales information.
unfortunately, the volume always changes and I cannot use a macro for
creaqting a Pivot table. When i select cell A1 and hit pivot tabel it
automatically selcts the range. In my macro it will only select the actual
range i recorded. IS there a way to go around that?

Thanks
Mike

Pivot tables and macros
 

You'll have to edit the macro to create a variable range (alt + F11 will
bring up the VB Editor). If, for example, your macro recorded the range as
"A1:D4200", you'll want to create a variable to capture the final row, then
use that variable in the range.
Dim FinalRow as long
FinalRow = Range("A65536").end(xlup).row
....
Then edit the range to read "A1:D" & FinalRow


"Mike" wrote:

i currently use macros to change some downloaded sales information.
unfortunately, the volume always changes and I cannot use a macro for
creaqting a Pivot table. When i select cell A1 and hit pivot tabel it
automatically selcts the range. In my macro it will only select the actual
range i recorded. IS there a way to go around that?

Thanks
Mike