I am having a little difficulty in correctly formatting a macro statement which I want to use to insert a formula into a specific cell. The source cell will change on a weekly basis but will be consistently filed and formatted.
This is the statement I am trying to use
where myPath is the full location of the RemoteFile and Weekly is the Sheet Name
I have tried all manner of combinations of "s and 's but I either come up with an error message or I get the text of the formula in the target cell.
Incidentally, is it possible to refer to the sheet by Index number, rather than by name?