I have the below code to hide a chart when there is no value in A1. The problem I have is A1 is actually a formula =IF(Sheet1!a2<>"",Sheet1!a2,"")
so it does not work when A1 is "blank". I need the chart to be hidden when the formula generates a blank and visible when the formula generates a value (sheet1 a2).
FYI i have 20 charts with 20 corresponding cells!
Can anyone help me fix the code?
Please Login or Register to view this content.
Last edited by Leith Ross; 03-19-2013 at 11:52 PM. Reason: Added Code Tags
Hello ea223,
Since the blank is an ambiguous condition indicating the cell may be blank because of the formula result or no formula at all, you can test if the cell has formuila as shown below...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hey, thanks but I am now getting the message 'object doesn't support this property or method' and it does not hide the chart when the formula in cell a1 produces a blank value? any ideas??
thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks