View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
al007 al007 is offline
external usenet poster
 
Posts: 118
Default Loop Column letter A to Z ??

The macro is used to replace row numbers in cells containing formula
only
e.g
if cell = =Sheet2!K10*10
Replacing row10 by 20 would only result in =Sheet2!K20*10 (& not
multiplied by 20)