I been able to get the code to got to
.Offset(1, 2).Formula = "=COUNTA('Sheet1'!$A:$A)"
But then when i try to add
.Offset(1, 2).Formula = "=COUNTA('["wb"]Sheet1'!$A:$A)"
it falls over
I am using 2010
Yes there is one workbook which is holding code, another workbook (extractsizechecker) which is where i want the results to go and teh folder with the files i want the forumula to be performed on.
Currently it is extracting data from extractsizechecker
It has gotton very confusing the code started with be able to put the results in the workbook which was holding the code but i was told i had to store the reuslts in another document and i have been trying to do that with no luck.
I hope that helps.