Quote:
Originally Posted by macropod
Hi lyngio,
The culprit is your 'Worksheet_Change' macro. Change:
Target(1).Value = UCase(Target(1).Value)
to:
If Not IsDate(Target) Then Target(1).Value = UCase(Target(1).Value)
|
Sorry it's taken a while for me to get back but I've been on holidays...
Anyways, Fantastic........Works a treat now!!
