Excel VBA Copy range into table

Question

I have been unable to figure out how to paste a range (specifically one row) into a data table using VBA.

Right now there is a range of data in a worksheet named "RawData". On another sheet there is a graph that starts at (1, 1) and goes to (100, 33). The variable ThisValue contains the name of the sheet containing the table. The variable x contains the row number of the range I am attempting to transfer.

I am currently using this code:

Sheets("RawData").Select
Cells(x, 1).Resize(1, 33).Copy
Sheets(ThisValue).Select
NextRow = Cells(Rows.Count, 1).End(xlUp).row + 1
Cells(NextRow, 1).Select
ActiveSheet.Paste

The problem that I am facing is that it pastes the range of data directly below the table and not in the table. Any help would be greatly appreciated.

But where would you like to copy to, which row exactly?

Kazimierz Jawor
– Kazimierz Jawor

2013-12-07 05:33:09 +00:00
Commented Dec 7, 2013 at 5:33 — Kazimierz Jawor
– Kazimierz Jawor, Commented Dec 7, 2013 at 5:33
To the first available (empty) row in the table.

user2005990
– user2005990

2013-12-07 05:56:21 +00:00
Commented Dec 7, 2013 at 5:56 — user2005990
– user2005990, Commented Dec 7, 2013 at 5:56

barryleajo · Accepted Answer · 2013-12-08 23:23:51Z

3

Tables should be addressed as ListObjects in VBA not as Ranges/Cells.

You should find what you require here in the section 'inserting rows and columns'.

answered Dec 8, 2013 at 23:23

barryleajo

1,9622 gold badges13 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA Copy range into table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related