See this (wait for the counter to stop in the download website):
http://files-upload.com/257895/LeastSquareMaths.xls.html
I've a Circular ref in the sheet called "Maths"
I cant see the wood for the trees at the min... heads up my a.s.

I have these options selected in my VBA Tools/Options/Editor dialog:
- Auto List Member
- Auto Quick Info
- Auto Data Tips

Ok I had posted a question about some code (Subject: Code issue -
before_save() - Filename with date stamp - worksheet), to which I got it to
work but now it is causing my Excel to completely crash.
Any ideas??? Also Why do I get 2 vbok pop up boxes????

Could someone tell this tourist why this is not working please??
Private Sub Workbook_BeforeSave()
   With ActiveSheet
       .Name = "As of " & Format(Now(), "MM-DD-YYYY")

I'm looking to create a database in excel to record Utilities usages
e.g.
Water
Electricity

Anyone who can help me to shorten two macros. both is in the same
Userform.
Userform has:
one combobox

I am opening an existing spreadsheet and appending rows from a SQL Db.  The
rows are being appended correctly where I want them to be, ex. starting at
N15.  However, the existing content, from A1:M519, is being wiped out.  The
data I am adding will always be placed at the end of ...

I'm looping through some workbooks in a directory, then adding new
sheets to my active workbook.  How can I test to make sure a worksheet
doesnt exist before I add it?  And if it does exist how do I activate
that sheet?  Something like this maybe?

I'm trying to find vba code to run a windows scheduled task. Any ideas?

I'm writing a macro to select and copy a large data matrix  (excluding
the header row) by using the following VBA coding.   Note:  the row
containing the column headers is row 5.
Range("A6").Select

Today, I have this strange  problem of dim. I don't have this problem before.
If I run the following program, variable d would automatically round up to
an integer. This happens to me any variable that I put at the end of the dim
statement if I have two or more variables.

I am trying to run a macro for all files in a directory.   Ronald was
able to provide me with the following code which replaces the
directory of a link souce with another directory.  The code is as
follows:

I have code that filters for unique records in place. This works great
but when I try to paste new values into the location which was
filtered, it causes the code to hang. I have determined this is due to
the fact that advanced filter hides rows in it's filtering process.

Hey all,
I have about 50 columns of data and need to create a chart for each column.  Currently
I am writing separate macro for each column.  The only thing that really changes is the
chart name, source data range, and series collection name. How can I write a loop to create

I do volunteer work with an out-of-state non-profit organization that runs
Office 2000. I wrote several VBA programs for them using Excel 2002.  I
sometimes get nailed on revisions that I send because of my newer version.
Almost always the problem is that I included system ...