I am trying to use 2 different variables and either the ROWS or RANGE command
in a macro to select a continuous block of rows. I want to copy this block
from one sheet to another sheet. I have been trying to use the following
syntax with no avail: ROWS(firstrownumber,lastrownumber).Select I also
tried using:
RANGE(firstrownumber:firstrownumber,lastrownumber: lastrownumber).Select I
have to use a variable, because the actual row numbers I will be copying and
pasting will change every time I run the macro. I can make it work if I only
select and copy one row at a time, but in one of my sheets I need to select
and copy 2880 rows of data, and doing that one at a time takes about 5
minutes. Any suggestions would be very much appreciated. Thanks.

Range(firstRowNumber & ":" & lastRowNumber).copy

Rows(firstRowNumber & ":" & lastRowNumber).copy

just do demonstrate from the immediate window:

f = 1
l = 2080
? range(f & ":" & l).Address
$1:$2080
? rows(f & ":" & l).Address
$1:$2080



--
Regards,
Tom Ogilvy


"Chad" wrote:

I am trying to use 2 different variables and either the ROWS or RANGE command
in a macro to select a continuous block of rows. I want to copy this block
from one sheet to another sheet. I have been trying to use the following
syntax with no avail: ROWS(firstrownumber,lastrownumber).Select I also
tried using:
RANGE(firstrownumber:firstrownumber,lastrownumber: lastrownumber).Select I
have to use a variable, because the actual row numbers I will be copying and
pasting will change every time I run the macro. I can make it work if I only
select and copy one row at a time, but in one of my sheets I need to select
and copy 2880 rows of data, and doing that one at a time takes about 5
minutes. Any suggestions would be very much appreciated. Thanks.

Tom,
You are the MAN! I have been struggling with that for several days and was
getting very fustrated. I knew it was a simple syntax error, but just
couldn't figure it out. Thank you again for the quick response and excellent
help!

Chad