Posted to microsoft.public.excel.worksheet.functions

Mal[_2_]

external usenet poster

Posts: 4

how to specify a range that is variable.

I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
--
Mal

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
variable range	John	New Users to Excel	2	July 21st 06 03:42 PM
Variable Range	sep1280	Excel Worksheet Functions	3	March 6th 06 07:17 AM
from Range variable	Marina Limeira	Excel Discussion (Misc queries)	0	January 22nd 06 02:35 PM
Variable in Range	aftamath	Excel Discussion (Misc queries)	2	October 6th 05 07:48 PM
How to use a variable for a range	Jeff Lowenstein	Excel Worksheet Functions	1	July 26th 05 02:14 AM

All times are GMT +1. The time now is 10:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us