View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nav Nav is offline
external usenet poster
 
Posts: 43
Default Using Dynamic Ranges in Get Data command

Hello

Is it possible to use a reference "Data" which is a dynamic range to be used
within a GetData command as per below:

'Get the cell values and copy it to DyRng
GetData MyFiles(Fnum), Application.Goto Reference="Data", Dyrng, False, False

If so what is the best way to incorporate this as I get a compile error for
this.

Thank you in advance for your help.

Regards,