View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default Auto Capital - (Further Question)

Kev

Thank you for your suggestion, although, I went with Gord's answer, I
appreciate your efforts though.

Gord

The original Code you provided had a small glitch in that it did not auto
cap until I clicked back on the cell again, dunno why it was doing it, but I
must thank you as this is by far a better alternative and works a treat.

Thx heaps to both.

Regards
Mark.