A
Abe
I have the following code, where I want to set rnge to all the cells in
column two that have values in them.
Dim rnge as Range
On Error GoTo nothingIncol2:
Set rnge =
Worksheets("SaveLoad").Range("B:B").SpecialCells(xlCellTypeConstants)
On Error GoTo 0
However, if there is nothing in the B column, it returns a Run-time
error: "No Cells where found".
Shouldn't the error GoTo catch this?
Thanks,
-Abe
column two that have values in them.
Dim rnge as Range
On Error GoTo nothingIncol2:
Set rnge =
Worksheets("SaveLoad").Range("B:B").SpecialCells(xlCellTypeConstants)
On Error GoTo 0
However, if there is nothing in the B column, it returns a Run-time
error: "No Cells where found".
Shouldn't the error GoTo catch this?
Thanks,
-Abe