copying rows from next sheet over

A

ayl322

I'm trying to copy a range of rows from one sheet over from the activ
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 clas
failed"
What am I doing wrong, and is there an alternative way to do this?

Any help would be appreciated
 
D

Don Guillett

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
 
Top