Recording Data Validation - stops working!

Hi all,

Ragulduy kindly provided me with a working DV. It works great (ensures first letter is capitalised, everything else must be lower). I then recorded myself entering this DV on a few non-contiguous blank cells. The formula applied fine.

However when I then try and apply it to my worksheet (multiple ranges - some blank, some not) - it throws up a RTE here:

Please Login or Register  to view this content.

The full, recorded code is:

Please Login or Register  to view this content.

Hi Norie,

Awesome!!! Thanks.