Saving to a specific column in a second sheet

[anthony1312002]

Hey everyone. I've got a challenge here. The code below works just fine. But as you can see in the highlighted portion of the code when I paste its pasting to the first column in the destination sheet. Is there a way to alter the paste portion so that I can save to the column of my choice in the destination sheet?

Please Login or Register  to view this content.

[Bernie Deitrick]

Change

Please Login or Register  to view this content.

to something like

Please Login or Register  to view this content.

[anthony1312002]

Thanks for getting back to me Bernie. Here is how I used your suggestion. But I'm getting an 1004 Application Defined or Object Defined error. What am I doing wrong?

Please Login or Register  to view this content.

[WideBoyDixon]

Hi Anthony,

You're using ws4.Rows instead of ws4.Cells

WBD

[Bernie Deitrick]

What he said....

[anthony1312002]

Sorry for not responding sooner. But thank you guys so much. This is exactly what I was looking for. Thank you again.