I was hoping someone could help me out here I have a macro that debugs on the
same spot.  But it's not everytime it's just like once everyother time.  It's
basically saying it can't find a certain worksheet but...it's right there, if
you get what I mean.  If your intrested in trying ...

I am using conditional formating in my VBA macro Code.  When I run
the macro I get subscript out of range.  In my workbook I have the
active sheet
activated.  Can some one point out what I may be doing wrong.

Hi to all,
I have a very strange problems with colors.
I have a program that does some database reports and brings those report to
the  user. Then the user can print and export to excel /using 3rd party

The named range ‘FileList’ houses file names in a current directory  I’m
trying to loop through that list but am not sure how to get this set up
correctly… I get a blank MsgBox and in turn the first file does not open.  I
want to learn how to stay out of the spreadsheet for this ...

I am doing regression analysis for tree size (independent variable)
and tree age (dependent variable).  I want to make a template that
will allow me to chart a dynamic number of trees (data points) and
tree types (series) on a scatterplot.  So, I have three columns:

I have a form that includes a number of inputs (we'll call it (name)
frmPO).  The user inputs the information from a purchase order (i.e.
company name, address, etc.) into frmPO.  One of the text boxes (i.e.
(name) txtPOItems) on frmPO includes an input for the number of items

I have created a userform wherein there is a combobox which refers the
masterlist
contents columns like:
Col. A = Old Item Code  Col. B = New Item Code & Col. C is Description.

In Excel 2000 is it possible to imbed some code in a worksheet that will
automatically save the file when it is closed (rather than go through the
"are you sure...." routine). The standard autosave add-in is already being
used but the user wants to be able to close the sheet and ...

Hi - I want to create a message box which opens at the end of the macro which
tells the user how many records (rows) exist on the worksheet. When user
clicks ok, the macro closes.
Please tell me how to code the msgbox that will do this.

I am trying to simplify compiling of data from different users.  Here
is the situation: A single master sheet is sent out to 5 different
regions.  In this master sheet are hundreds and sometimes thousands of
shipping lanes.  To simplify these lanes have an predetermined id

Is it possible to access the "Update quotes" function from an Excel macro?  
If so, How?

1)  I have created a user form for adding record to my worksheet. Each a
record is added, I want my serial number field to be populated with a serial
no in the worksheet - continuing from the last record.
2)  On the same user form, I have a "Find command button" to find a record.

Im looking to create some data validation in say cell a2, that says if
cell a1 = "a", then allow a2 to accept a number, if a1 = anything else
then dont allow entry into a2.
Is it possible using custom data validation...? I cant seem to get any

I am writing a macro in Excel 2000
Cells.Select
Selection.Copy
'then move to another sheet in another workbook.

Sub species_unhide()
   Sheets("BID").Select
   Application.Goto reference:="raw1"
   Selection.EntireColumn.Hidden = False