help with conditional formatting macro

[MATT.B]

is there a better way of doing this I'm having an issue where it changes $b3 to $b56783 but if I step the macro using F8 it works correctly
this macro is ran every time the work book is closed I was having an issue where if you clicked while closing the macro would have unpredicted results so I changed the code from testold to testnew now im having an issue with the link between $b# and row #

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[spitfireblue]

Please Login or Register  to view this content.

[MATT.B]

Please Login or Register  to view this content.

I'm trying not to use .select as it is causing errors when some one happens to click while macro is running is there a method I can use that doesn't include using .select?
my full code is

Please Login or Register  to view this content.

[spitfireblue]

What about like this?

Please Login or Register  to view this content.

[MATT.B]

same results
row 3-10 is set to =OR($B65529="W",$B65529="w") (in sequence)
then at row 11+ its set to =OR($B1="W",$B1="w") (in sequence)
this started me thinking so I changed the code to only set row 3 and no others and it comes out as =OR($B65529="W",$B65529="w")
for some reason the formula isn't being set correctly unless I use the .select method I think I'm stuck doing it that way but thank you for the help

[spitfireblue]

I think that we are overthinking it...
Try something like this at the start of your code:

Please Login or Register  to view this content.

and then end your code with this

Please Login or Register  to view this content.

Then you should be able to use Select