Copy Blank columns without header

[Revathi kannan]

Hi all,

I am facing challenges in my coding while I am getting the entire column as blank.

> I need to copy the data from one sheet to another sheet wherein i have standard columns in the both the sheet.
> I will copy and paste the each column separately from one sheet to another because that is my project requirement.
> My codlings are working fine if my columns are filled with data but the problem starts if the entire column is empty wherein the headers are included in the destination sheet. I just want to show only blank without headers.
> Also my copy range always starts with 3rd row with Used range of Column A.

Please assist me. I have attached the sample file for reference.

Thanks.

[Vraag en antwoord]

You forgot to post the code.

Please Login or Register  to view this content.

[TMS]

Not sure why you can't just copy the block but here you go:

Please Login or Register  to view this content.

[TMS]

@Vraag en antwoord: note:

> I will copy and paste the each column separately from one sheet to another because that is my project requirement.

[Revathi kannan]

Hi Vraag & TMS,

Thank you so much for your reply.

But i will paste the details as per the Used range in my destination sheet based on Column A. Below is my code.

Please Login or Register  to view this content.

[Revathi kannan]

Thank you so much all .. I tuned my code and now it is working perfectly.

[TMS]

Maybe this then (untested)

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.


Maybe post your tuned code so we can compare notes

Why DO you have to copy column by column? It would make more sense (based on what you have told us so far) to copy the whole range in one go.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Revathi kannan]

Thanks TMS. Will do it..