Sharkz00ka
New Member
- Joined
- Aug 25, 2014
- Messages
- 3
Hi everyone,
I have a macro that deletes rows from a set of pasted data. My problem is that I have a pivot pointing at that data. When I paste my extraction and delete the columns, the data range of the pivot reduces (for example from A:AA to A:W).
Is there a way to keep a fixed range, even if I delete columns? (the pivot data range points to the correct columns post deletion)
I have a macro that deletes rows from a set of pasted data. My problem is that I have a pivot pointing at that data. When I paste my extraction and delete the columns, the data range of the pivot reduces (for example from A:AA to A:W).
Is there a way to keep a fixed range, even if I delete columns? (the pivot data range points to the correct columns post deletion)
Last edited: