B Bernie Deitrick Nov 12, 2003 #2 SF, Use an outer loop (and set the SearchSubFolders to false, along the lines of Dim i As Integer For i = 501 to 999 ... ..Lookin = "homogeneity testing\400" & i ..... ..... Next i HTH, Bernie MS Excel MVP
SF, Use an outer loop (and set the SearchSubFolders to false, along the lines of Dim i As Integer For i = 501 to 999 ... ..Lookin = "homogeneity testing\400" & i ..... ..... Next i HTH, Bernie MS Excel MVP
