Posted to microsoft.public.excel.programming

VistaOnMyMac :) VistaOnMyMac :) is offline

external usenet poster

Posts: 1

Calculating Average using a Variable Range

I need to use the average function in the row after the last row of data in
column B that calculates the average of range (B10:last cell of data in that
column). Then I need to fill that row to the right with that same average
function, stopping the fill at the last column of data.

This spreadsheet for my teachers will vary in size and my novice ability
with VB has me stuck. I would really appreciate any help with this.

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
Calculating an average	Maggie	Excel Worksheet Functions	1	August 22nd 08 03:50 AM
Calculating Average	ub	Excel Discussion (Misc queries)	2	July 16th 08 05:14 PM
Calculating an average using VBA	Ben	Excel Programming	2	August 2nd 07 09:26 PM
Calculating the average	Andy_Trow	Excel Discussion (Misc queries)	3	July 27th 07 02:15 PM
Calculating Average on variable sized datasets w/VBA	nano	Excel Programming	1	February 3rd 04 02:36 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us