Hi Excel-lent People,
I am trying to average assignment scores in a gradebook.  Assignment
scores are entered into cols starting with AO.  On row 10 are the max
points possible for assignments (for instance, AO10 may be 20 for 20

I normally use a format control drop down box.  This is my first time using a
VBA Combo Box.  I have two questions that are probably very basic but I can't
get this figured out.
I am using ListFillRange to define a column that has dates.  This is

How do I create a custom menu that opens with a specific worksheet? How do I
add menu items to the custom menu and how do I get the menu items to run
code?
Thanks!

Hi experts
Thanks in advance for your help.
I have two files - "Tool" and "MasterFile".
I need to pick up 3 columns (how many ever populated rows are there)

How do I create a button on a worksheet to execute code?
Thanks!
Steve

I am recording a macro that will delete some columns and then insert one
column.  After I stop the recording and run the macro it inserts two columns
not one?

I´have a problem with merging several textcell together. In one kolumn i
have textcells and in another column numbers. I´d like excel to merge the
textcells together if the row have number zero. The merge text should also be
on different rows.

Anyone,
I am using Office '03 - Excel.
I have a treeview heirarchy, with checkboxes, which is assembled top-down
(of course).  After I have completed the heirarchy, I wish to disable (gray

Can someone help me determine what the general process involved in
accomplishing the following task would be?  I am trying to automate a system
in which data from a CSV file is used to automatically populate various
tables in an Excel worksheet.  I then want those tables to be ...

I have multiple series on a chart and only a few display at any time based
on a UserForm selection.
I wish to have a legend displayed at all times, showing only the
LegendEntries for the series that are currently visible.   The

I'm a Home Loan Officer in Los Angeles and I'm creating a Finance sheet for
some realtors I work with for there open houses and I'm looking to give
examples of payments.
So what I need is the formula of the Loan Amortization of a 30 year fixed

I have a toolbar with a "RefreshNow" button that I want to preempt so I can
do some extra steps.  I have ID'd the toolbar and button object code as :
commandbars("Business Explorer").Controls("RefreshNow")
I have tried :

hi, everyone:
I have two columns, column A and Column B. Column A is the date in
format of mm/dd/yyyy. Column B is the cost corresponding to each date.
How to get the sum of cost for each month in pivot table? I would also

Excel 2003
I am trying to use a macro to search column a for the Text "RD".  I have
used the code below many times to find each instance in a column.  Now, I
want to find each instance, but after one instance, assign the value to a

I'm interested in using a combo box and command button from the control
toolbar.  The combo box will contain the names of all the worksheets in this
file.  This is done with a dynamic named range.  The command button will act
like a "submit" button to take the user to the desired ...