Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty and Is Nothinq problems
Am having problems in testing for the values held by range
variables. As I understand it, if the range variable holds more than 1 value then I should test using If IsArray, but I can't get that to work, either. At the point where the following sequence will run, the variables have the following values: HideCols = True (Dimmed as Boolean) Global_ExclColRng has the value 'Nothing' Wkbk_ExclColRng has the column 'D' Sheet_ExclColRng has the value 'Nothing' All 3 variables are dimmed as Range If HideCols = True Then On Error Resume Next If Not IsEmpty(Global_ExclColRng) Then Global_ExclColRng.EntireColumn.Hidden = True ElseIf Not IsEmpty(Wkbk_ExclColRng) Then Wkbk_ExclColRng.EntireColumn.Hidden = True ElseIf Not IsEmpty(Sheet_ExclColRng) Then Sheet_ExclColRng.EntireColumn.Hidden = True End If On Error GoTo 0 End If How do I get this to work, please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Loop Statement through If Not IsEmpty Then Paste into Destination | Excel Discussion (Misc queries) | |||
Way around CUT problems... | Excel Discussion (Misc queries) | |||
Form If IsEmpty Syntax | Excel Discussion (Misc queries) | |||
SUM Problems | Excel Worksheet Functions |