Adapt Code

[PaulCooke]

Hi could someone advise on how to adapt the code below to check to see if any of the N cells do not have text entered in them.

The macro shown below currently checks each sheet to see if there are missing times in K and L only if data has been entered in D & G

I am trying to adapt it and create a new macro so that it only checks N to see if data has been entered but again only if D and G have data already in them.

I'm assuming I only need to change this line (in bold) but really have no clue what I'm doing to be honest as nothing I try works !

Please Login or Register  to view this content.

I would be really grateful for any advice you can offer

Many thanks

FULL CODE AS IT IS AT THE MOMENT

Please Login or Register  to view this content.

[Kaper]

As a matter of fact it checks for non-empty D:G so D, E, F, G

if you really want to check only D and G, and if at least one of them is filled, then check if N is filled try:

Please Login or Register  to view this content.

[PaulCooke]

Hi Kaper many thanks for taking the time to reply.

My lack of knowledge showing regarding it checking D, E, F & G cells but that is exactly what I need it to do and then check only N cells to see if they are filled in.

I have tried the code you kindly wrote but it fails on this line

Please Login or Register  to view this content.

.

As I do need D:G 'checked' is there an alternative way to do this?

Thanks again for any advice or help you can offer

[Kaper]

Try (only inner part the rest is the same):

Please Login or Register  to view this content.

[PaulCooke]

Brilliant - That Works perfectly !

Thank you so much for your help on this Kaper much apprciated

[Kaper]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

PS. I also tried by Private message focus your attention to: Rule 1 of our Forum [/I]RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[PaulCooke]

Will do thanks and sorry for the errors on the rules regarding the thread title