View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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")