vba to copy every singe cell using WITH

[Muktar888]

Hey guys,

I adapted this code, I am trying to copy every single cell as is for the stipulated column, but it only copies rows in that column where there is a rank in column A. You can run my macro to see the copy over issue.

attached is my code and excel.
the 3rd tab shows what it should look like when copying columns A and C into dws from sws column A & B. if you make this work, il adapt it for the rest of the columns.

It also needs to paste in the Funds sheet from row 3, not row 2.

Please Login or Register  to view this content.

Thanks guys

[Richard Buttrey]

Surely all you neeed is:

Please Login or Register  to view this content.

[Muktar888]

Surely all you neeed is:

Please Login or Register  to view this content.

Hey Richard

I tried this but i see that it copies column A & B, this is fine.

But il need to copy specific single columns that are not next to each other.

I will try this and let you know the outcome.

Sorry been busy, but still need this.

[Norie]

Why are you copying individual cells?

Couldn't you use something like this without looping?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.