Cell's insensitive for upper lower letter case

Hi.
I do have small code with in the particular cell checks for todays day. I want to ignor the upper or lower cases i mean there should be no matter how i writte the week day "Friday", "friday" "FRIDAY" "friday", fRIdaY" and so on.
I did try the Ucase(Range("C1").Value) but it didnt work is there any way to make it work?

Thanks

Please Login or Register  to view this content.

Isn't this the wrong emphasis?
Rather than trying to cater for and work around different spellings in C1 by using VBA code, why not ensure C1 always contains the correct spelling by making it a data validation cell and listing the options available.

Use the worksheet PROPER function to match the weekday names as spelled in your code, and assign the converted value to a variable.

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Originally Posted by Juolupuki

In the cell "C1" will be copied data from diferent workbook and there not always spelled in same way, istead correcting it manually would like just ignore.
If in cell i copied with the spelled "friday" or in other way it will not triger the macro, will triger just for "Friday".
Im using this macro on
Private Sub Worksheet_Change(ByVal Target As Range)

In that case use code like

Please Login or Register  to view this content.

Perhaps code like this:

Please Login or Register  to view this content.

You're welcome and thanks for the rep!