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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Dynamic Ranges in Get Data command
I've not done coding relative to Pivot tables, and it appears that GetData is
related to them. If you have a dynamic range (Data) already defined, You could try something like this: Dim DyRng as range Set DyRng = Worksheets("Sheet1").range("Data") "Nav" wrote: 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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Dynamic Ranges in Get Data command
Thanks, but that doesn't work.
The GetData is in relation to using ADO, in order to compile data from several files. "Barb Reinhardt" wrote: I've not done coding relative to Pivot tables, and it appears that GetData is related to them. If you have a dynamic range (Data) already defined, You could try something like this: Dim DyRng as range Set DyRng = Worksheets("Sheet1").range("Data") "Nav" wrote: 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, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Dynamic Ranges in Get Data command
I'm sorry, I won't be able to assist. I hope someone else can.
"Nav" wrote: Thanks, but that doesn't work. The GetData is in relation to using ADO, in order to compile data from several files. "Barb Reinhardt" wrote: I've not done coding relative to Pivot tables, and it appears that GetData is related to them. If you have a dynamic range (Data) already defined, You could try something like this: Dim DyRng as range Set DyRng = Worksheets("Sheet1").range("Data") "Nav" wrote: 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, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Dynamic Ranges in Get Data command
What is your GetData routine ?
NickHK "Nav" wrote in message ... 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, |
Reply |
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 |