copy active row and repaste values

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
 
J

JLGWhiz

Sub Macro3()

ActiveCell.EntireRow.Copy

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

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
copy named range & paste values 2
Not seeing cells as blank 2
Run macro from active workbook whose name keeps changing 20
Loop several sheets - not all worksheets of workbook 8
Something in this is causing a crash 2
Select specific worksheets & copy - code problem 2
Error using offset 1

Top