dynamic Range in ADO
 

Dear experts:

This is my VBA I learned from Ron de Bruin's website
'Get the cell values and copy it in the destrange
'Change the Sheet name and range as you like
GetData FName(N), "PO New (2)", "A1:C1", destrange, False, False
How can I cnange the range( A1:C1 ) to dynamic range since the data in other
files could change, so I want to always update the combined data.

Many thanks,

Frank