This seems like it would be simple enough, but I can't seem to find an answer anywhere.
I have a formula worked out that shows the last row in shreadsheet.
I then want to you this number in some VBA code.
Say the cell with the last row number is B1, what's the proper want to say (in VBA)
Range("A2:A**Row number in A1**").Select