Clearing cell contents from within a function
Thank you in advance for any assistance that may be offered! I rarely use macros and have never played with Visual Basic, so please be patient with my ignorance!
Has anybody ever cleared the contents of a small range of cells from within another function such as an "IF" statement? I thought this would be easy, but in fact, has turned out otherwise. To my dismay, I found out you can't run a macro from within a function either (which would have made the problem trivial!). Using a "conditional format" to hide the cell contents is not really an option as I need to eliminate the text so other calculations are not performed.
Any assistance would be greatly appreciated!
Just wanted to update my previous question---thanks to a couple other folks who suggested the following solution:
Since I was unable to have the macro run directly from within an IF..THEN statement in the worksheet, it was suggested to use a checkbox control, then insert the clear-cells command within that sturucture. Worked great. Thanks to all again!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1