Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic range reference and use of common code
I have 2 questions. 1. I need to graph a range that may change each time the code is run. How do I reference it? The starting cell is always fixed to F2. But the ending cell (bottom right cell of the range) is dynamic. It is determined by how many members in a 2-dimensional array myarray(13,18). The number of elements in the first dimension changes, but the the number of elements in the 2nd dimension is always 18. shall I code it? 2. I need to use the following piece of code in multiple places in my program: ..fieldnames=true ..rownumbers=false ..refreshonfileopen=true Basically I'm setting properties for an imported file. I need to import multipe files, and I suppose I can use the same property settings for each one of the imports. How do I code it so that I can write that code once and use it repeatedly? Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic range reference and use of common code
For the first, if you always have 18 series with a varying amount of
points, you could just make a dynamic chart, which has series based on dynamic named ranges. Check out examples and links: http://www.geocities.com/jonpeltier/.../Dynamics.html If the number of series is varying, you can't do it quite so smoothly, but you could define a dynamic named range (same instructions as above setting up the range), then use it in a SetSourceData statement for the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ clui wrote: I have 2 questions. 1. I need to graph a range that may change each time the code is run. How do I reference it? The starting cell is always fixed to F2. But the ending cell (bottom right cell of the range) is dynamic. It is determined by how many members in a 2-dimensional array myarray(13,18). The number of elements in the first dimension changes, but the the number of elements in the 2nd dimension is always 18. shall I code it? 2. I need to use the following piece of code in multiple places in my program: .fieldnames=true .rownumbers=false .refreshonfileopen=true Basically I'm setting properties for an imported file. I need to import multipe files, and I suppose I can use the same property settings for each one of the imports. How do I code it so that I can write that code once and use it repeatedly? Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic range reference and use of common code
Take a look at Jon Peltier's site:
http://www.geocities.com/jonpeltier/...x.html#hdrDyno In article , clui wrote: 1. I need to graph a range that may change each time the code is run. How do I reference it? The starting cell is always fixed to F2. But the ending cell (bottom right cell of the range) is dynamic. It is determined by how many members in a 2-dimensional array myarray(13,18). The number of elements in the first dimension changes, but the the number of elements in the 2nd dimension is always 18. shall I code it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic range where the reference cell can change | Excel Discussion (Misc queries) | |||
macro code to get dynamic range | Excel Discussion (Misc queries) | |||
Vlookup - dynamic range reference? | Excel Discussion (Misc queries) | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Reference to a dynamic range | Excel Discussion (Misc queries) |