Excel Macro does not Replace text in formulas for several work
Yes thanks, It reaches the second sheet. It seems more like the replace
function is not working properly when i try to shift from "=function(a,b,c)"
to "&function(a,b,c)", the "&" only to stop calculation of an add-in
function.
But if I instead try with replacing "=function(a,b,c)" by "=ffffff(a,b,c)",
sort of keeping a formula intact starting with "=", the replace function seem
to work better
Rgds /Jan
"Pete_UK" wrote:
Have you tried single-stepping through the macro to discover what is
happening? You seem uncertain as to whether it reaches the line:
Sheets("Sheet 2").Select
Hope this helps.
Pete
|