Hi

I've been trying to get this to work. I want to programmatically insert
this formula into a cell in the active worksheet. I want to link the two
cells which are in the same workbook.

='Main Sheet'!$E$9

I've tried various ways with no luck. I just don't seem to get this.

Here's my latest try.

With ActiveSheet
..Range("G9").Formula = "'=Main Sheet'!$E$9"
End With

The formula is there but as a string.

Thanks