set wb = workbooks.open(myFile)
for each wksht in wb.Worksheets
for i = 2 to myCount
wksht.Range("C1:T5000") ' This will actually be an index/match
Trying to figure out how to select a range inside of the for each loop of a set of worksheets. Need this for an index/match function that I'm creating, but I'm getting an "Object doesn't support this property or method" error.