Thread: UCase?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vbastarter vbastarter is offline
external usenet poster
 
Posts: 14
Default UCase?

Hi, Its a simple question. I have a large file and i would like to check if
any of the cells are upper case. I thought i could do something simple like
if strtext = ucase(strtext) then....

but then its not able to identify ucase cells that way. Is there any
alternative way to achieve this??? Many THANKS