Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting
Hi, I'm having a problem copying a range from one sheet and copying it t the next. To give you an idea of what I'm doing, I have filtered ou results from a spreadsheet and am trying to copy these results to th next sheet using the following code: Code ------------------- Worksheets(1).Range("A1:S" & Worksheets(1).UsedRange.SpecialCells(xlCellTypeLas tCell).Row).AutoFilter _ Field:=1, Criteria1:=groups(i1), VisibleDropDown:=False Worksheets(1).Range("A2:S" & Worksheets(1).UsedRange.SpecialCells(xlCellTypeLas tCell).Row).Copy Worksheets(2).Activate Worksheets(2).Cells(currRow, "A").Past ------------------- (This is part of a bigger macro) When I run the macro, however, I get that the Object doesn't suppor the method. Am I using the wrong method? Thanks in advanc -- Raman32 ----------------------------------------------------------------------- Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474 View this thread: http://www.excelforum.com/showthread.php?threadid=54256 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting | Excel Worksheet Functions | |||
Pasting help | Excel Programming | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Pasting Q | Excel Programming |