Copy and paste to destination range of cells only if empty

[RonnG]

I am looking for some VBA code that will allow me to copy the cell contents from say cells A1:A30 to only empty cells in C1:H30.

So cell value in A1 will be copied to columns C1:H1 only if empty. The same for A2 to C2:H2, etc.....

Range is not specific (example only but same worksheet). I just don't want to paste over any existing data in destination cells.


Thanks for any suggestions.

[Trebor76]

Hi RonnG,

Maybe this:

Please Login or Register  to view this content.

Regards,

Robert

[RonnG]

Thanks Robert I think I can work with this....