setting a range automatically

[Brian Young]

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian

 

[Mike]

You could Highlight the entire A column and enter a name into the Name box
Like MyRange then change your formula to this
=AVERAGE(MyRange)

 

[Brian Young]

Hi Mike

Could you advise if I was to do this in a Macro what would the command be ?

Thanks

Brian

 

[Brian Young]

Hi

should have added that i may want the range to start at A5 and omit the
first 4 rows

Cheers

brian

 

[Mike]

=AVERAGE(A5:A65500)

 

[Ron Coderre]

You might want to consider using a Dynamic Range Name, which automatically
expands and contracts to accomodate the data (and without VBA code).

See Debra Dalgleish's website for instructions;
http://www.contextures.com/xlNames01.html#Dynamic

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP