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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA version of ISBLANK()
OK Ignore this. I'm wrong. Doesn't crash on ALL empty cells just one
particular cell Have tried IsEmpty() but that still crashes Thanks "Nicholas B" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA version of ISBLANK()
Nick,
You could also use Len(a cell reference) Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Nicholas B" wrote in message... OK Ignore this. I'm wrong. Doesn't crash on ALL empty cells just one particular cell Have tried IsEmpty() but that still crashes Thanks "Nicholas B" wrote: 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 |
Reply |
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) |