In VBA, sheets can be referred to by either name or location.
Example:
Sheets("Sheet2").Activate
or

Hi.  Someone just called me about a formula that one of the managers thinks
he needs.  I can do what they want in three rows, but am not seeing how to do
it in one row, and have it change with the AutoFilter.
They have something like the following, across rows and columns:

I am trying to create what I would call an if/then formula in Excel 2003. If
someone types the letters PTO into a cell have tat equal zero in the formula.
I have a sum formula of a set of cells I want Excel to be able to add a zero
into the formula if someone types the letters ...

I have the following code which works fine. My question though is how can it
be simplified (which I am sure it can).
For Each mycell In Range("C31:K31,M31:U31")
       If mycell.Offset(-25) = 3 And mycell.Offset(-5) - mycell.Offset(-23)

I have a command using the IF function that is as follows:
=IF(M3>=80,"YES","NO")
I would like to be able to add a green background if the YES condition is
met and a RED background if the NO condition is met.  is there a line of code

I am working in a worksheet in which 1 is equal to a Want and 2 is =
to a Desire.
I need to tally each column so that at the bottom of the sheet one row
will add up all the 1's in each column while ignoring the 2's in that

Folks:
How can I get a list of all the Functions available in Excel 2003 ?
Thanks,
Jo.

I need to set a new cell's value to a numeric digit by saying :
If(s4="Jack's", 1, ""). But it won't work b/c of the apostrophe inside of
"Jack's".
Is there a way around this without altering the data?

Would it be possible to evaluate A1:A2000 and show me the top 20 values in
B1:B20  ...with an array formula?
I think to have seen it the other day, but I cannot reproduce nor find it
...

In Cell B31 I want to enter the formula showing the greater value between
cells B29 and B23. IF B29 is greater than B23 display B29 or IF B23 is
greater than B29 display B23.
Thanks in advance

Hi, Everyone, I am not sure if I am double posting so I apologize before hand
if so.
This shoud be very easy, I am using the ISBLANK() function but I want the
results to be TRUE if there are values within the cell and if there are NOT

In excel sheet we have data like ,
A            B                     C
(Avg)       (Month)            (Result)
12           12                    PLA

Hi,
I need to create a series of 1000 cells down a column. They will be in this
format:
MM1A

I was working on a formula in my budget.
Right now, all deductions and deposits are entered in the same column
(column B). With the current balance in the account in column c.
I differentiate between what I spend the money on by highlighting the cell

I have a groups of 6 cells that are in column A (A1, A2, A3, A4, A5,A6). I
want to change the 6 cells in column A to create new columns B1,C1,D1,E1,F1 &
G1. Then the second set of 6 cells in A (A7,A8,A9,A10,A11,A12) become
B2,C2,D2,E2,F2 & G2)  and so on. I am using Excell 2007. ...