Posted to microsoft.public.excel.programming

Tim Childs[_5_] Tim Childs[_5_] is offline

external usenet poster

Posts: 9

Error Control - null rnage

Hi

What test can be used to stop the following code

Range(.Cells(iFirstDataRow, iTestCol), .Cells(lFinalRow,
iTestCol)).SpecialCells(xlCellTypeFormulas, 7)
erroring when there are no cells identified by the Goto-Special command?

i.e. I sometimes get error 1004 - "no cells were found"

thanks

Tim

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subscript out of Range Error if Null	[email protected]	Excel Programming	0	November 9th 07 05:50 PM
counting dates within a rnage	[email protected]	Excel Programming	2	March 6th 06 05:44 PM
Rnage Finder	JosephC	Excel Worksheet Functions	1	February 21st 06 12:33 AM
summing data that match critieria in a rnage	sandyix	Excel Discussion (Misc queries)	4	February 21st 05 01:39 AM
Invalid use of Null error	Stuart[_5_]	Excel Programming	2	October 19th 04 04:18 PM

All times are GMT +1. The time now is 08:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us