Loop Column letter A to Z ??
Surely, this won't work. If you try to replace a letter, it might also
replace that letter not in the cell ref, such as the S in sheet.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"al007" wrote in message
oups.com...
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)
|