I am a beginner and would like to create a macro that inserts an address into
a worksheet. It works fine if I am in cell A1, because the code calls up
cells A2 and A3 with: Range("A2").Select or Range("A3").Select.
What code do I use to make the next line of the address go to the ...

Is is possible to say
=IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
?

If I have several named cells in say 10 worksheets, and I delete sheet 8,
then I have some named ranged left out there with no valid reference.
How can I check the validity of a named cell in vba?  I have this so far...
Sub test()

I get a type mismatch error on this. I have one book that is on
windows scheduler, when it opens (on the scheduled time) it auto runs
the macro's in another workbook. It works perfectly except I want it
to close all workbooks without prompting me "do you want to save". How

Is there any way to prevent a user from closing a dialog box by clicking on
the   X   in the upper right corner?

We are creating Excel reports for electrical equipment rated power (Amps),
e.g.
Equip       Equip
Rated       Full

I have the following code that I use to save to a csv.  The .csv file for
upload has a limit of 90 lines, therefore I would need to have multi files
created with lines 1 to 90 on one file with a 1 on the end of the file name.
Then lines 91 to 181 with a 2 on the end of the file ...

I'm looking for help with a macro that will allow me to find every row in
column B where the value is "FC" and will copy the range Bn:Tn to the row
below.
For example:

When you write a SQL Query for a QueryTable of Pivot Table, you have
to parse the query in order not to exceed 255 chars -if you're storing
the SQL Query in a string variable-.
PivotTables

I have made a very cool econometric interface for Excel. However, I have a
little problem: some advanced Panel Data techniques use MANY variables, and
large matrixes. Some of these matrixes have to be inverted, and I am sadly
surprised to see that the Minverse function can only ...

I have a file ("orinignal") that has tabs one, two, three.....
I want to write a macro to export tabs to seperate files and save them
automatically. FIle one would include tab one, two, three. File two would
include tab one, two, four, etc.

How do I get data to display in the bottom half of the split pane?
I have 2 separate database queries now and I want the results of the first
one to appear in the top half and the results of the 2nd one to appear in the
bottom half.

 We've got two combo boxes (off of the forms toolbar) that we keep in
sync, meaning changing the selection in the first one kicks off a
macro that applies a filter to a range, and copies the result to the
area that is used as the source for the second combo box.  The input

I'm have 52 sheets named 1,2,3,etc., that I want to create named ranges on
in the following fashion...
sheet 1 (named "1") has A:C named w1s
sheet 1 (named "1") has D:F named w1c

I am pretty much a beginnner when it comes to VBA/macro programming in
excel. I am stuck with probably the simplest problem in excel. There
is a form based combo box with all the properties specified using
format control option. I need to find a way to make the listIndex