Array to Range Questions

[stfeliciasredpanda]

I have the code below which pulls two columns into an array and then moves those into a destination sheet. Two issues I'm hoping for help to solve: 1)How do I set the source range to skip the header row? 2)How do I set it to paste the values into the first blank row on the destination sheet?

Please Login or Register  to view this content.

[Keebellah]

Hi, weel, VBA and the code is just 'dumb code', what I mean to say is, it does exactly what YOU tell it to do.
If you do not want the header row, the you you have to 'tell the code' where the header row is and (eg: you can set a constant hrow with the row) and start from the first row under that row
The first blank row, well, the same story, YOU 'tell the code' which row is last filled row, you can calculate that using simple vba code and set that up ws the starting row eg LastRow) and start from there
This means your code needs some minor modifications but I'm sure you can pick it up from here

probably something like this:

Please Login or Register  to view this content.

This was typed without testing in Excel so maybe a syntax error but this is the idea

[protonLeah]

Please Login or Register  to view this content.

[stfeliciasredpanda]

I had tried a variant of that and had the syntax off. Thanks for showing me where it went wrong!