find and replace

[jw01]

Hello

I have the following macro which copies data from selected range and paste the formulas into the other worksheets...however, it's for some reason, not changing or find/replacing the worksheet name :S

Please Login or Register  to view this content.

any ideas..pls help, thx you.

[Cutter]

I'm not a VBA expert but aren't you asking the code to do that copy/paste only when there is NO match to the sheet name AND the sheet is visible????