VBA Copy and Paste Question

[WWII_Buff]

I want to copy the contents of a range as long as the number of cells in the column have data. Starting from Column D1.

Here is my code:

Worksheets("DATASHEET").Range("D1:BD" & LastRow).Copy

However, the code is copying from A1 vs D1, any suggesting please?

Thanks.

 

[Fluff]

Do you have any merged cells?

 

[WWII_Buff]

Yes I do actually.

 

[Fluff]

Then that's probably the problem.
Best bet is to remove them, merged cells are a PITA & I avoid them like the plague.
If you are merging cells in a row have a look at this

 

[WWII_Buff]

Ah! So you just taught me that there is a way to center text without merging columns! Outstanding! Thank you so much!

 

[Fluff]

Glad to help & thanks for the feedback