I am new to vba and have been searching for a way to automatically hide rows based on the result of a formula that returns either Y or N. The following code is what I have found but it only works if I enter Y or N. What do I need to change in order to make it work with a formula result rather than a manual entry? Any help would be appreciated.
Please Login or Register to view this content.
That code WILL actually work because it fires on ANY change.
So, if for example, M39 hasand you enter "N" in cell A1, the event handler will fire and find the value "N" in cell M39.Formula:
Please Login or Register to view this content.
You probably DON'T want it to fire every change though.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I've been playing with this and realize what my issue is, the Y/N is picked from a pull down on another worksheet "DATA_INPUT" and looks like this
Formula:Please Login or Register to view this content.
The worksheet "QUOTE" which I have the macro assigned to is a completely generated sheet with no input on it, it is simply a results page. I guess my question now is what do I need to change in order to allow this macro to work with a result from another worksheet?
Put the event handler behind the Data_Input worksheet and monitor cell B18
I'm not sure what you mean by event handler. My experience with vba is about one day of doing Google searches. Could you show me what you are describing to do? Thank you for your help so far.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks