Macro Not Working

[brentjohn]

Greetings,
I have been working on this macro for over 3 hours and cannot figure out why it is not working correctly. On Sheet24 I have placed the following macro. It is to go to Sheet1 (which is hidden) and confirm what value is in cell G835. If the value is blank, it is to insert "True". If the value is "True" it is to insert "False". If the value is "False", it is to insert "True". It only wants to insert "true" if the cell is blank - nothing else.

Please Login or Register  to view this content.

[Richard Buttrey]

What do you mean by not working correctly.

And in fact using .Select is unnecessary and wasteful.

Have you tried instead code like

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[brentjohn]

Thank you both very much!
Fluff, I tired your suggestion and it works great!

[Fluff13]

Glad we could help & thanks for the feedback

[jolivanes]

@brentjohn.
Just as an afterthought.
If someone with the same problem uses Google in an attempt to find a solution, do you think he'll enter "Macro not working"?
See #1 in the Forum Rules.

[brentjohn]

jolivanes,
Good point. However, how should have I labeled my request.

[jolivanes]

@brentjohn
I would not worry too much about it.
Something like "Change Cell Value If Other Cell Value Changed."
Or something to that effect.
It's all for the next time.