I have 2 worksheets, A and B, and there is a cell "b2" that contains a
drop down list of division names (used data validation list). When each
different name on this drop down list is selected the 2 worksheets
change to show the results of this specific division. I would like to

I've been looking for a solution to this problem, I need to get a count
of all rows that have an "X", but not the total number of "X" in the
range. Any solutions or tips? Thanks!
    A    B    C    D

In Excel 2003, how do I get the Formula1 property of the Validation
object to refer to a function name?
This gives me error 1004:
Sub Macro1()

In Excel 2003, I'm using ADO to read a CSV text file. It works fine
unless I try to specify a specific field in the SQL statement:
Function GetList()
Dim rs As ADODB.Recordset

rFor example:  SUMIF(B2:B7, "Apple OR Orange", C2:C7) If it's an apple or an
orange, sum their values in column c.
It does not work.  Can anyone help?

When using a UDF in Excel as an Array formula (CTRL-ALT-DELETE), how do you
error handle to avoid getting #N/A in cell ranges which are larger than
results of the array.  See example below.
Thanks

My users may or may not have a folder called "C:\Audits".
When they run a certain macro, it should check to see if the folder exists,
and if it does not, create it and then save As the open Excel workbook to the
Audit folder under a new name.

I am running into a problem when I try and run a macro that copies a
sheet that has a pivot table in it and moves it to another folder and
then copys-past special-values the sheet.  When I try and run macros
that do this I get an error message when the macro finishes processing

I am unable to enter more that one character (2.00 but not 26.00) in a
textbox.  I have the format set to ###.00 in another procedure.  I
think this is the procedure that is causing the problem.  Is there a
format length in here?

I am in need of some function or macro to populate a column in an excel
spreadsheet for existing rows with the user's network login id.

I want to take a list of customers and sort them by 'date of next visit'
(closest date being at the top of the page).  After each visit, I would
assign a new date (for next visit) and the sheet would update itself
automatically, so each day I just have a list of customer at teh ...

Public Sub getdata()
Dim nextrow As Long
Dim entry1 As String, entry2 As String, entry3 As String
Dim entry4 As String

Good afternoon,
I have created a form that has multiple textboxes.  I was wondering if
there is code that I could use to combine the data from the textboxes,
i.e. 1, 2, 3, and then have that entered into a cell on one of my

I've created a macro that creates individual workbooks from all
worksheets within a multisheet workbook adding some event procedures to
the individual workbooks. I made use of Chip Pearson's page
"Programming To The Visual Basic Editor" to accomplish part of this

Excel 2003 limits lookup functions to searching 16,384 row of the source
worksheet. Is there a way to expand this window?