View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default copy active row and repaste values

keep getting runtime error....

want to copy active row and repaste values only.


Sub Macro3()

ActiveCell.Offset(Rowcount).EntireRow.Copy

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

End Sub