troubleshooting Question

Append data from a range to a table listobject using vba

Avatar of Thrawn3000
Thrawn3000Flag for Australia asked on
Microsoft ExcelMicrosoft Applications
4 Comments1 Solution564 ViewsLast Modified:
Hi Team
I would like to Append a range to the bottom of a table a listobject in excel using
vba, for some reason my current code crashed when I was appending two different ranges to a  table giving me a runtime error 1004  "application defined or object defined error " pleas help . The underlined line is causing the error

Sub AppenBalanceValues()

Dim rData As Range

Application.ScreenUpdating = False

    Set rData = Range("rnwin_retain")
   [b] [u]Range("tblAccountingViewFeb[[#Data],[metric]]").Offset(Range("tblAccountingViewFeb[[#Data],[metric]]").count, 0).PasteSpecial (xlPasteValues)[/u][/b]Application.ScreenUpdating = True
Application.CutCopyMode = False

End Sub

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros