View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default VBA to say IF cell = any one of 3 values,then do something

So you can't write an unqualified range even when testing... I thought it was
just me! :-)
--
HTH...

Jim Thomlinson


"JE McGimpsey" wrote:

Yup - artifact of testing. Glad it was obvious...

In article ,
"PCLIVE" wrote:

I had to remove the period before "Range"...but other than that, it does the
trick.