Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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(x lCellTypeConstants) 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
specialcells(xlLastCell) and method global range error | Excel Programming | |||
SpecialCells | Excel Programming | |||
SpecialCells Method Question | Excel Programming | |||
VBA ON ERROR does not work with SPECIALCELLS | Excel Discussion (Misc queries) | |||
Drillthrough MDX ERROR(Error.Number:-21467259) ?(urgent question) | Excel Programming |