vba range

[Sharp]

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

[mrice]

Have you considered the UNION method?

[gajendra.gupta]

Hi,

You can write the same code for multiple ranges as below:

Please Login or Register  to view this content.

Regards,
Gajendra Gupta