Thread: range or string or long type
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
  
Posts: 274
Default range or string or long type
Hi Bartman,

Perhaps

If Not rng5.Value = "a" Then

or

If rng5.Value < "a" Then

Regards

Michael Beckinsale

Reply With QuoteReply With Quote