I am trying to cut down on the memory my Excel program uses.
One problem is the use of whole column references , i need to use A$1:A$2000 rather than A:A UNLESS I have more than 2000 rows.
In particular, I use a lot of Sumifs statements, particularly to summarise pivot tables. The number of rows displayed by the pivot table can vary wildly. Is there a way of setting the last row in a target range as a variable? It is relatively easy to calculate the last cell
Lastrow=Match("Grand Total",A:A,0)
Can I define ranges by reference to this variable? ie (A$1:A$(LASTROW)) and if so how? I could use VBA,but is there another way?
Bookmarks