I need to place a formula in a cell which contains both a standard ( "=Page2!E5") and R1C1 formula but I am have trouble with the VBA code syntax.
The formula is placed in page1, column G in a row determined by a row variable (ExRow). It needs to find the value in page2 cell E5, and divide it by the value in page1, column D of the same row.
So the VBA code would look something like this:
However, the result for ExRow=54 is =Region!'D5'/E54 when it should be =Region!D5/E54
Any suggestions? Thanks!