| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation with dynamic ranges | Excel Discussion (Misc queries) | |||
| Dynamic data ranges | Excel Worksheet Functions | |||
| dynamic setting of data ranges | Charts and Charting in Excel | |||
| data validation, dynamic ranges | Excel Worksheet Functions | |||
| consolidate data, dynamic ranges | Excel Programming | |||
Threaded Mode
