it could be asked for from any col past M but always starting at col C
thanks

"Don Guillett" wrote:


Let's see, you didn't answer my questions, did you?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pcor" wrote in message
...
Thanks for thr quick reply....BUT can you please tell me HOW to accomplish
that!
Thanks

"Don Guillett" wrote:

You can do this easily with a worksheet_selection event in the sheet
module
but you would probably want to restrict to a certain range or columns and
rows or it would fire EACH time you select ANY cell. Never less than col
C
and never more than column _____? rows________?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pcor" wrote in message
...
I would like a macro to do the following:
I would place the the cursor in any cell and this macro would give me
the
average of all the entries to the left if the selected cell. EX: I
place
the
cursor in cell M12.
I want this macro on display in cell M12 the average of all the values
from
Col C12 to Col L12. Note that there may NOT be entries in all the cells
in
that range. Also the start point would always be col C .Thanks