This enters the formula as I want it in Cell A1 of the worksheets. When complete, Cell A1 in each file gives me the NAME? error. If I double click the formula and then hit return, the formula starts working again. Is there any way to get this formula rolling within VBA and avoid the error?
Many thanks,
Gr8Scott
PS - I'm adding these formulas to show the length of the data contained in each worksheet. I intend to use this length in an offset formula within my Sumproduct commands in linked files to shrink the number of rows searched per command. It should boost overall performance.
Workbooks.Open Filename:= _
"\\X_DATA\RNP_FCST_ORD_PO.xls"
Range("A1").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(E:E,""<>"")"
Workbooks.Open Filename:= _
"\\X_DATA\RNP_SAFETY_ONHAND.xls"
Range("A1").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(E:E,""<>"")"
Many thanks,
Gr8Scott
PS - I'm adding these formulas to show the length of the data contained in each worksheet. I intend to use this length in an offset formula within my Sumproduct commands in linked files to shrink the number of rows searched per command. It should boost overall performance.
Last edited: