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 |
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) |