I find I often need to do something to a range on a worksheet and I am always using something like A2:A100 which is fine until I have 101 rows of data. Is there a way to find the last row automatically?
or some such?
Alternatively I have a formula to find the last row and put that row number in a cell so would this be a way to accomplish the same thing
=Sum(A2:A&"E1") where E1 contains a formula that calculates the number of the last row?
Thanks in advance,