Need to have 2 worksheet selection.change rules in 1 worksheet

[winwall]

OK. so attached is a file that when cells in column F and G are clicked in - they auto populate with "NA" and "U". now this is all working fine - EXCEPT for the fact that rows 387-391 need to populate with a "y" and "n" respectively. now i can actually see when i click on the cell - the Y or N populates and then it changes to "NA" and "U". i am attaching the file. all the code is on the sheet "fresh thinking audit".

if someone could PLEASE see what i have to do to not have two codes run on the same cells i would be so grateful!!!

Please Login or Register  to view this content.

[judgeh59]

would adding an Exit Sub after you set your Target.Value = "N" mess you up? same for the "Y"

[winwall]

Changed - thanks

[judgeh59]

Hi WinWall --- have you tried what I put in Post #2?....

[winwall]

judgeh59 - yes and no go unortunately - just kills everything

[judgeh59]

In the Worksheet_SelectionChange()....change the 392 to 387 in the ElseIf (Target.Row > 24) and (Target.Row < 387)....setting it to 392 allow the other code "NA" and "U" to execute....give it a try

[winwall]

I will try that thanks

[winwall]

and...............Fixed! thanks GUYS!

[judgeh59]

glad I could help....Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputations feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...