Hello, I need an average of last 6 scores discounting the lowest and the
highest.  I need to also discount blanks/zero for days the person does not
show. Thank you for your time and patience with me.

Can you dynamically set a comment size based on the amount of text it holds?
I see a way to set the size using comment.shape.height, etc. but is there
some sort of "autofit" similar to range.columns.autofit() ?
Thanks.

I'm having a ridiculous time over a very simple thing that I should be able
to do; I want to insert the following formula and I'm using the following
function to do it:
Formula:  =D5&E5;">

I am trying to get a cell in a particular column to change to the current
date, but only when any other data in that row is changed.  Each cell in
that column then should have the last date that a cell was changed in that
row.  We need to be able to perserve the current manual ...

I have a spreadsheet that i run a macro on to trim it down into a table and
then paste it into Word. I would like to be able to do two things: -
1. How would i set the range as a variable so that, should the range change
in future, the VBA script will not display any errors?

Is it possible to change the format of the MsgBox string?  How can I bold and
enlarge the font of the the message string?
Thanks,
Ed.

Sorry, if this sounds like dumb question but I'm an excel programming noob.
Basically what I'm trying to do is determine what workbook(index wise) is
the one closing during the "Worbook before Close" method.
For example, lets say I have 5 workbooks open in my Excel session and I

Howdy Folks,
I often work with laboratory analytical data that comes to me in
multiple spreadsheets. Before I bring these data into a database, I
combine the separate Excel files by hand into one. Is there a way to

Hi all,
I need apeend 150 files xls into one , but the name's files is variate ,
thanks

I have data in columns A:P65000 on "DataSheet". (Row 1 includes the
header for each row.) In column P, I have the group names.
I want to move (not copy) each row to its own sheet (and name it)
based on the unique group names in column p.

I'm preparing some route charts to give the transport guys to pick up
my team mat's
When prepared far a week the route no's will go up to 140..(like wt-01
to wt-140)

I would like to identify vith a VBA code, if the chart that i am editing is
is embedded in a powerpoint presentation or if is just an excel file opened
by excel.
My point is to fix the color chart bugs between 2003 and 2007 powerpoint

With Range(Current_Sheet)
               .FormulaR1C1 =
"=SUMIF(NDIRECT(R5C),RC1,OFFSET(NDIRECT(R5C),0,R1C,ROWS(NDIRECT(R5C)),1))"
               .Value = .Value

I'm trying to automate Outlook from XL to generate an email using LATE
BINDING. I have the following code so far, BUT it breaks when trying to
create a MailItem:
Dim oOL As Object

Is it possible to create a macro which can send a mail on daily basis
with an attachement on specific time
thanxs in advance