Thread: Select Case with Text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default Select Case with Text
post your code

--
Don Guillett
SalesAid Software

"Marie" wrote in message
...
I am using
Select.Case.Offset(0,2)
Case 70
and it works great. Now I have to select text in the same row
so I have
Case BE
It is not picking it up but it is not giving me an error. Is it because it
is not numeric?
I have tried "BE" and Case is BE nothing seems to work.
Any suggestions would be greatly appreciated!
Thanks!
Marie



Reply With QuoteReply With Quote