Thanks, Tom. I appreciate the info.

Ed


"Tom Ogilvy" wrote in message
...
In VBA, you need to pass a range object when a range is need in a formula.
In a worksheet, the functions understand A1:B9 refers to a range - in VBA
you have to use a range object.

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
Thank you, Tom. It works great!

As for the $ as an invalid character, is that just the dirfference
between
writing a formula, and writing VBA? In other words, I shouldn't assume
that
just because a formula in a worksheet is good, that's what VBA will
recognize in the same way?

Ed
<SNIP
I tried writing
' B2:B7000 is my range; C2 is an empty cell
IF (COUNTIF($B$2:$B$7000,C2)=0 THEN
' next routine
ELSE Exit Sub

but it keeps telling me $ is an invalid character. What am I
missing?