Thread: can VB ignore capitalization
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default can VB ignore capitalization
Ideas?

Patient: "Doctor, it hurts when I do this"
Doctor: "Don't do that.
--
Jim Cone
Portland, Oregon USA



"dawall33"
wrote in message
When I compare cell a1 to b1 in a formula capitalization is ignored, (ie. 2a
= 2A). This same check in a VB script fails. I'm trying to create a sheet
based of a text box and my check against the names passes but I get an error
trying to name the new sheet with the capitalized version of the name.

Ideas?
Reply With QuoteReply With Quote