Continuous column copy / Non-continuous column paste (VBA)

Hello.

I'm a rookie to macros/VBA and to this website/forum. I appreciate any help I can get on my question (a rookie question).

I'm slogging my way through a macro that essentially copies specific (but non-continuous) columns of raw data from one worksheet ("data") to another worksheet ("fundings"). Both worksheets are in the same workbook. The code I listed below works (albeit, it is ugly), but I'm having a hard time pasting my data differently than how I'm copying it. What I need to do is paste the data into specific (non-continuous) columns on the destination worksheet. I'm using the Union function to copy the non-continuous columns from the raw data. This function combines the non-continuous columns and makes them look continuous. There are nine columns selected in "data" (see code below), and this data is then pasted to the first nine columns in "fundings". What I need to do is paste the results in specific columns of the destination worksheet ("fundings"). For example, I want the first-through-fourth copied columns ("A-D") to paste to the first four columns of the destination sheet (this already happens), and I want the fifth column of copied data ("G") to paste to the seventh column of the destination sheet (not working). I can't figure out how to skip columns in the pasting function.

Apologies for being lengthy. And thanks in advance for the help.

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)

Why not do two copy and pastes. First the Union copy and paste the first 4 columns and then the last column copy and paste to column G.

Here is the syntax using the defined variables in your code. Hopefully, I have extracted them correctly.

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

That's because to reference 2 columns, you need to specify the start row for the start column as well, i.e. C10:D20. What you have done was only C:D20, for example.

Try changing to:

Please Login or Register  to view this content.

Note: the CStr() is most likely unnecessary too