Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fixed Rows at top of sheet | New Users to Excel | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
inserting rows at common word in a sheet | Excel Discussion (Misc queries) | |||
Hid rows in a hidden sheet. | Excel Discussion (Misc queries) | |||
Copying whole rows based upon one criteria | Excel Discussion (Misc queries) |