I'm currently using the following to select data rows that start in a pivot table at cell A7.
I later paste it, but I'm getting errors when that pivot table has 0 or 1 row in it because then it selects all of the blank rows below the pivot table.
How do I account for these 0/1 row situations?
Thanks in advance for any help - the only thing I could find got me to the code shown below. The 0/1 row exception wasn't anything I've seen asked in my google searches.
- Range("A7", Range("A7").End(xlDown).End(xlToRight)).Select
- Selection.Copy
Bookmarks