Do only if Cell not empty on range

[FallingDown]

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

[Richard Buttrey]

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.

[FallingDown]

Thanks Richard

How strange, I tried that and it did not work...
Anyway... seems to be OK now

Many thanks

Yeah, I know about the merging issues, I do try to avoid it ;-)
My collegue already told me of about this :p

[FallingDown]

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

[Richard Buttrey]

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.

[FallingDown]

Richard

Thanks again, but not sure this helps.
Maybe I was not clear enough
The part the user copy/pastes is from another report

Then the user pastes those data into this worksheet (ranges A:N)
But when the users pastes it ends in the runtime

[FallingDown]

Hi Richard

OK, so now I really have it

Please Login or Register  to view this content.

Now my last question is: I am sure this could be improved somehow, but since I am still quite new to VBA I was wondering whether you could take a look at the code?

[Richard Buttrey]

Hi,

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

[FallingDown]

Hi Richard

Sorry for nor replying earlier, was a bit busy doing other things

Anyway, I managed to do what I wanted

Please Login or Register  to view this content.

Many thanks again for the help