Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear All,
I wish to turn the line of code .WebTables = "4,8,12,16,20,24,28" into something more dynamic. In the above case I am pulling down 7 tables from the one web page. As you can see they are every 4th table starting from table 4. Sometimes, however, the number of tables change. If there are 10 tables then I would be pulling down the following... .WebTables = "4,8,12,16,20,24,28,32,36,40" I want to have my code start off with an input box that I can state the number of tables I need. I then need this variable to help create an array that dynamically sets the .WebTables ... similar to .WebTables = arrTables ... if this is possible to do... Could anybody either confirm if this could be done, offer an alternative, or guide me in anyway? Regards, andym |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Dynamic Variables | Excel Programming | |||
dynamic variables | Excel Programming |