hiyas all!
currently, i am using code such as the following:
WorksheetFunction.CountIf(Sheets("Serial Numbers").Range("A2:A6000"), str(i))
where str(i) is what i am trying to count
what i want to do is replace the "Sheets("Serial Numbers).Range("A2:A6000")" portion to a hard location of a closed workbook on, say, the D: drive.
for instance, the spreadsheet could be at: "D:\RM\SerialNumbers.xls" and wanting worksheet "Serial Numbers"
is this possible? if so, is there an easy way to find code this? and am i even in the right thread?
Bookmarks