| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Nothing and Null
What should be used with range variables if they are empty - IsEmpty(r) or r
is Nothing? Provided that r is declared as Range? What is the best way to check if range contains no cells, for example list on worksheet contains only coulumns headers? Currently I use both techniques - either Set r = Nothing and later test if r Is Nothing then...or r = Null and later test if IsEmpty(r) then... Thanks Mike510 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| if a1 = null then a1 = b1...how do I do this? | Excel Discussion (Misc queries) | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
| Using Nothing and Null | Excel Programming | |||
Threaded Mode
