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