Home VBA .Range "Object Required"
Reply: 0

VBA .Range "Object Required"

user566 Published in June 21, 2018, 6:29 am

I've looked into this for the past hour or so and can't figure it out.

Sub Paste1()
    Dim NextRow As Range
    Set NextRow = Range("A" & Sheets("AMCurrent").UsedRange.Rows.Count + 1)
    NextRow.PasteSpecial Paste:=xlValues, Transpose:=False
    Application.CutCopyMode = False
    Set NextRow = Nothing
End Sub

Getting "object error" on row 4, "AMPaste.Range("A3:F3").Copy". Unsure what to do.

Any help would be appreciated.

Thank you.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.355853 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO