[SOLVED:] Check if the text is ALL UpperCase (UCase) [Archive]

crmpicco

05-27-2005, 04:11 AM

If Trim(Range(sRange).Text) <> "" Then

Similar to this how can i check if the text is ALL UpperCase (UCase)

TonyJollans

05-27-2005, 04:17 AM

If Range(sRange).Text = UCase(Range(sRange).Text) Then ...