| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to test if a workbook variable is valid
Hi,
When using a variable of type workbook in an expression, it is necessary to test if its content is valid. For instance that it is not "nothing". However syntaxes like "if wb < nothing then ..." or "if not wb=nothing then ...." do not work. Is there any solution, possibly with a different approach. Thank you in advance. Jean-Pierre B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Analysis of measured test results by INTERVAL (variable) | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| test for not blank, use value in cell and set as variable | Excel Discussion (Misc queries) | |||
| How to test if a repertory is valid | Excel Programming | |||
| Test that a workbook is open | Excel Programming | |||
Threaded Mode
