I'm trying to create a macro to select the range of the pivot table automatically but I have a blank column in Column C so I can't use the code below
The range should be B5:E33 for this example
Please Login or Register to view this content.
I'm trying to create a macro to select the range of the pivot table automatically but I have a blank column in Column C so I can't use the code below
The range should be B5:E33 for this example
Please Login or Register to view this content.
I found this code that fins the last row in a column, but how can I change it to select the last column and last row starting from B5
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks