Using VBA to select entire rows
I have a macro in which I want to copy entire rows from one sheet to
another. The reason I want to copy the entire row is to get the row heights.
The number of rows on the source sheet varies so I am using two variables
(firstRow = 2, lastRow=RANGE("G65536").END(xlup) ). For example if the last
row is 12,450 then ROWS("2:12450").COPY is what I want to do. But, I haven't
figured out how to do this using the variables.
I'm sure this is very basic but I just haven't done it before.
I'd appreciate any help.