Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i secuire Sheet Same time Update the Pivot Table | Excel Worksheet Functions | |||
Spinner macro for Pivot Tables. | Excel Worksheet Functions | |||
Substitute for Pivot tables? | Excel Worksheet Functions | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
What's the best way to learn Pivot Tables and using Macros in Exc. | New Users to Excel |