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,ActiveSheet.Name!F:F,1),6,4))
Can you please help me solve...