Thread: Loop Column letter A to Z ??
View Single Post
  #4   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 ??
To Expand:

For i = 65 To 90
.Formula = Replace(.Formula, chr(i) & ReplaceFrom, chr(i) &
ReplaceTo)
Next i

In this sufficient to solve your problem?

Joseph Mc Daid

Reply With QuoteReply With Quote