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