A quick question on setting up variables in a formula.
I have the current formula:
ActiveCell.FormulaR1C1 = "='" & strfile & "'!R21C4"
I am using it to link several workbooks together. That have several worksheets in them.
"strfile" is the workbook file name, This works just fine. My problem is I can't seem to get the formula on the next pass throughthe loop to look at the next worksheet in "strfile". Does anyone know the syntax to look at the same file and the next sheet in a file.?
Any ideas are much appreciated.
I have the current formula:
ActiveCell.FormulaR1C1 = "='" & strfile & "'!R21C4"
I am using it to link several workbooks together. That have several worksheets in them.
"strfile" is the workbook file name, This works just fine. My problem is I can't seem to get the formula on the next pass throughthe loop to look at the next worksheet in "strfile". Does anyone know the syntax to look at the same file and the next sheet in a file.?
Any ideas are much appreciated.