copy active row and repaste values

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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
 
Sub Macro3()

ActiveCell.EntireRow.Copy

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

End Sub
 
Back
Top