Thread: Loop Column letter A to Z ??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joseph Mc Daid Joseph Mc Daid is offline
external usenet poster
  
Posts: 11
Default Loop Column letter A to Z ??
Perhaps you could loop from 65 to 90, and user chr(i) to retrieve the
character. chr(65) returns capital A while chr(90) returns capital Z.

HTH

Joseph Mc Daid

Reply With QuoteReply With Quote