Hi
try
Range("A65536").End(xlUp).Select
Selection.entirerow.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False

--
Regards
Frank Kabel
Frankfurt, Germany


Thanks.

Is there a way to copy and paste the whole row instead of only one
column?


---
Message posted from http://www.ExcelForum.com/