Re: VBA query
Thanks for the info, are you able to to explain the below? i've never used intesect before and i think i need to extend the range.
If Not Intersect(Target, Range("C:F")) Is Nothing Then
Target = UCase(Target)
The range i need to capture is D:AZ any column either side can be excluded.
many thanks again for your help.