Hi,

can anyone help me adapt this code so that i can change the range to select multiple areas, such as A1:C1 and G1:H1

CODE:

GetData MyPath & MyFiles(Fnum), "Sheet1", "A1:C1", destrange, False, False
Next
End If

The rest of the code can be found in the link below if that helps;

http://www.rondebruin.nl/ado.htm#folder