Posted to microsoft.public.excel.programming
|
|
any clue why this won't work?
Isn't that Row 16 which is perfectly acceptable?
--
HTH...
Jim Thomlinson
"Jim Cone" wrote:
NextEmpty could be in row one and Offset(-1,0) gives you row zero.
Also, it is not possible to paste the contents of an entire row
into another row starting at column 16. ( try A1 not A16)
Following these guidelines helps us all out...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Calle"
wrote in message
Worksheets("resultatpivot3").Range("A16", NextEmpty.Offset(-1,
0)).EntireRow.Value.Copy _
Destination:=Worksheets(1).Range("A16")
|