Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys. I'm looking for a way to keep the following line:
Set oRange = oSheet.Cells.SpecialCells(xlCellTypeFormulas) from returning an error. I do know that a similar line of code: Set oRange = oSheet.Cells.SpecialCells(xlCellTypeBlanks) can be kept from raising an error if I use the following undocumented excel featu x = oSheet.Application.CountBlank(oRange) ...is there a similar one for xlCellTypeFormulas? -K |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling for xlCellTypeFormulas | Excel Worksheet Functions | |||
Specialcells | Charts and Charting in Excel | |||
VBA ON ERROR does not work with SPECIALCELLS | Excel Discussion (Misc queries) | |||
AutoFilter /specialcells | Excel Programming | |||
specialcells(xlcelltypeblanks) | Excel Programming |