Do only if Cell not empty on range

Hi all

I am running this code:

Please Login or Register  to view this content.

It's running fine, except I would not like it to run if the value in col. O is empty
I should incorporate this in this line

Please Login or Register  to view this content.

Any ideas?

Thx
FD

Untested but maybe

Please Login or Register  to view this content.

And just an observation. It seems to be generally acknowledged that merging cells is not really good practice since they can cause real problems with other Excel functionality and that you should avoid this unless absolutely necessary. There are usually other work arounds, and often a standard Format Alignment 'Center Across Selection' choice will do for centering across a range.

Sorry Richard

I just tested again, and now know why it did not work for me

If you copy/paste anything somewhere else with more then two cells, then this part you've added ens in runtime error 13 - Type missmatch

Ah OK. Didn't realise more than 1 cell might be involved.

For situations like this I usually build in another test such as
IF Target.Cells.Count >1

to trap if someone tries to copy more than one cell.

Hi,

Can you attach the workbook and also the other workbook from which the user copies cells.