TheAntiGates
09-28-2006, 05:49 PM
Is there a simple way to display a range's areas or formulas, as you see under menu item Insert/Name/Define ? I.e., the "refers to" string?
If not, would I need to parse and loop with regions and areas? Would I
- check .HasFormula and then grab .Formula? or .FormulaR1C1?
- take rng.areas.count and build it with semicolons if multiple?
- loop through that count with the "Items?" How do I address them? rng(1), rng(2) ?!
Use .Formula or .Text ?
Tell me it's already available, please!
If not, would I need to parse and loop with regions and areas? Would I
- check .HasFormula and then grab .Formula? or .FormulaR1C1?
- take rng.areas.count and build it with semicolons if multiple?
- loop through that count with the "Items?" How do I address them? rng(1), rng(2) ?!
Use .Formula or .Text ?
Tell me it's already available, please!