this one drove me so mad i came looking for help!
so, i have been trying to write a macro to go to a root location, open every workbook in said directory and return the value of A2 from each sheet.
to start i just tried getting the values to post within a worksheet, but i cant get this to return a value:
range? cells? something else??Please Login or Register to view this content.
=SOLVED=
should be:
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Cells(1, 2)
Next i
still need help making this run for a directory...
i made a directory list and was going about this the hard way of opening each file by name, but would like to find a universal way. all files in folder are excel files.
Any help greatly appreciated! I am new to the For loop command and links to GOOD references also appreciated.
Bookmarks