What's the proper VBA syntax for selecting rows when a variable
is involved?
Rows("Endrow:2000").Select sure doesn't seem to work.
In my worksheet, "endrow" is row 830. I want to select all rows
in between 830 and 2000 then delete them.
endrow = Range("A65536").End(xlUp).Row
Thanks in advance.
is involved?
Rows("Endrow:2000").Select sure doesn't seem to work.
In my worksheet, "endrow" is row 830. I want to select all rows
in between 830 and 2000 then delete them.
endrow = Range("A65536").End(xlUp).Row
Thanks in advance.