Thread: What is the proper dot.syntax to insert a select case within a With /End With Statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JeanPierre Charron JeanPierre Charron is offline
external usenet poster
  
Posts: 24
Default What is the proper dot.syntax to insert a select case within aWith / End With Statement
Thank you Garry, but my cases are Alphas, not Numerics. "<063", "304", "386" etc...
..
Will the following statement change to handle Alphas ?
Select Case CLng(.Range("A2:A" & LRow).Value)
..
Thank you for your help.

J.P.
Reply With QuoteReply With Quote