Can someone turn the following formula into a select statement:
IF(ISBLANK(M4),"",IF(ISNUMBER(--MID(M4,2,1)),"Manual","Auto"))
Basically I'm tagging a record based on a value, if the second character in
the string contained in the specific column (field) is a number I want this

I am currently working with a Pivot Table. What i am trying to do is
determine if a Pivot Field is visible or not, and if it is, then i want to
make it hidden. To set a Pivot Field to hidden, i use the following code:
   Set pf = pfs.Item("Sum of Actual")

I am very novice....so I have not found enough "simple" info to solve this
problem....
I need a macro that searches out the rows labelled "Archive" (in Column E)
(in the "Master" sheet), cuts and pastes the whole row to another sheet,

I understand the use of this command:
Menu.MultiPage1.Pages(8).Enabled = True
BUT what I would like to do is not use a page number and use the Pages name
instead, is this possible?

I have used the method of inserting a formula in a cell using '=
if one insert "=a1" in a cell (a2) the excel treats this string as a
formula and executes its.
But i a application I insert a vlookup in cells

Below is my macro to draw bar chart  Pattern DarkUpward Diagonal if
Rng2.value in data sheet >3.  Today, there are no data and I have this error
'data type mismatch'
How can I fix this

I'm curious what the default file type for Excel 2007, and is it possible to
override it somehow?

We have a VB program and runs from one file and tries to open another file
which is located in the same directory.  The other file is called
"Updatefile.xls."  THis macro runs fine at one computer that  has Excel 2003,
but doesn't work on another computer that has Excel 2000.  It ...

I have a Master Workbook that I have to update manually. Then I have many
users that have their own copy of the same file but with different names to
show users of the file. I need a function that will update their file (just
the one sheet, call it Final Data) from the master ...

I'm running a macro that pull data from excel file #1 to Excel File #2
The Macro is in excel file #2
it uses the sumif and offset formulas in combination with a ranged name
linked to excel file #1 (there are 43 worksheets of informatiuon in this

I don't know if one exists or not, but is there a function in VBA that would
return a number representing the week of the year (0-51, or 1-52) when passed
a date?  similar to how year() or day() pulls out the year or day portion of
a given date?

Below is the code from Microsoft to apply category labels to an XY data
series.
I've changed the SeriesCollection and Offset values to fit my chart and it
works fine.

Can anyone tell me if there is a maximum number of controls that Excel can
handle on a user form?  I have a user form with a multi-page control on which
there are many textfields, labels, and command buttons.  The form recently
stopped being visible when run and crashes Excel.  I ...

I recently upgraded to 2007 and am trying to open some old workbooks in
2007.... when I try to run some functions I programed myself I get an error
that says ATPBAEN.XLA not found..    what does that mean?  How do I get my
old functions and macros to run?

I am programming a data entry worksheet for my employer.  I use Excel 2004
for Mac, they still have 2000 for Windows.  I have spent a lot of time coding
so things will work on both platforms, but this one has me stumped.
I am using the Onkey function to trap the use of the Add ...