copying rows from next sheet over
 

I'm trying to copy a range of rows from one sheet over from the active
sheet, and paste them onto another sheet.

This is what I tried:

ActiveSheet.Next.Range("a2:b100").select
selection.copy

However, I'm getting the error "selection method of the range class
failed"
What am I doing wrong, and is there an alternative way to do this?

Any help would be appreciated!


--
ayl322
------------------------------------------------------------------------
ayl322's Profile: http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=487235

copying rows from next sheet over
 

try
Sheets(ActiveSheet.Index + 1).Range("a2:b100").Copy

--
Don Guillett
SalesAid Software

"ayl322" wrote in
message ...

I'm trying to copy a range of rows from one sheet over from the active
sheet, and paste them onto another sheet.

This is what I tried:

ActiveSheet.Next.Range("a2:b100").select
selection.copy

However, I'm getting the error "selection method of the range class
failed"
What am I doing wrong, and is there an alternative way to do this?

Any help would be appreciated!


--
ayl322
------------------------------------------------------------------------
ayl322's Profile:
http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=487235

copying rows from next sheet over
 

it works beautifully! thank you~


--
ayl322
------------------------------------------------------------------------
ayl322's Profile: http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=487235

copying rows from next sheet over
 

I probably should have added that you do not need to do any selections. This
line will work by itself from the destination sheet.

sub copyit()'all you need

Sheets(ActiveSheet.Index + 1).Range("a2:b100").Copy range("a1")
end sub



--
Don Guillett
SalesAid Software

"ayl322" wrote in
message ...

it works beautifully! thank you~


--
ayl322
------------------------------------------------------------------------
ayl322's Profile:
http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=487235