| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for existence of range
Greetings,
TIA for any help In the sub below, how can i test for the existence of the Range referred to in rng <rng is nothing seems to be the wrong idea. Sub Test() Dim rng As Range Set rng = Range("A1, A4, A6, A8") rng.EntireRow.Select Selection.Delete MsgBox rng Is Nothing ' returns 'False' End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TESTING A RANGE OF CELLS | New Users to Excel | |||
| TESTING A RANGE OF CELLS | Excel Worksheet Functions | |||
| Testing a person's age to be within a range | Excel Worksheet Functions | |||
| Testing for existence of a formula | Excel Worksheet Functions | |||
| Cell in Range Testing Function | Excel Programming | |||
Threaded Mode
