| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA version of ISBLANK()
Anyone know how to get VBA to check if a cell is blank before reading its
formula ? If it was just a single cell I can point to it using a formula [ Eg =ISBLANK(D12) ] and use VBA to read the value of that Cell (the one with the ISBLANK() Formula). But I've many cells I want to test, cannot find a VBA equivalent to ISBLANK() and if I use the following line FormulaB4Change = CStr(ActiveCell.Formula) The code crashes on empty cells Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
| Wrap Text: Print Version different than Screen Version | Excel Discussion (Misc queries) | |||
| Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
| How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) | |||
Threaded Mode
