| 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 |
| 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) | |||
Threaded Mode
