Macro to paste a formulae using the "ActiveSheet.Name" in the destination cell.

[r2fro]

Hello there.

I'm using a macro to paste a formulae into a destination cell on another worksheet.

The problem is that I need the Macro to put the "ActiveSheet.Name" into the formulae:

ActiveCell=INDIRECT(ADDRESS(MATCH(9E+99+306,[COLOR=#ff0000]ActiveSheet.Name[/COLOR]!F:F,1),6,4))

Can you please help me solve this?

Thanks