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