Why is it in excel 2003 I can no longer press CTRL+SHIFT+ARROW Keys
when trying to select a row or selection when entering the details in
sum equations.

My Dear Vba Guru's,
I'm doing a "sumif" formula for this project, my range is the "code"
and "downloads". My problem is the "code" is based on the "content
type" column and the "code" is only unique per "content type" If i make

easter day formula excel Sample Spreadsheets in spanish
'=FLOOR(DAY(MINUTE(IJ20/38)/2+56)&"/5/"&IJ20,7)-34
'=FRANC((JOUR(MINUTE(A1/38)/2+55)&"/4/"&A1)/7;)*7-6
This is what i got but does not work in spanish

Hi Experts,
i have a column where i need to look for words PTO, NPT, ANP, UNP,Tardy,
FMLA or STD and add the next cell value to the Total PTO, Total NPT, Total
ANP.... at the end of the worksheet.

I am working on Excel 2007 Beta version.
I am facing a problem while calling a DLL in VBA for Excel 2007.
My DLL is located at the currrent directory location and i have declared it
in my VBA code as follows

Can anyone help me make the following code more effecient.  I keep repeating
the same formulas, so I think there might be a much more effecient way of
writing my code.
[L3].Value = 975000

Hello group,
I'm trying to hide a user-defined menu item in Menu bar during
following event:
Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)

The below code suppose to clear the values in the Range to = ""
But for some reason it works if i run the macro from an activeworksheet,
but it does NOT Clear the values in ALL shets(Minus the named 3 sheets).
I also had to add the (On error resume next) as i was getting a Cannot ...

Can anyone help me with code that can automatically creates a new tab with
the click of a commandButton.
I would like the code to loop through column A (starting in A2) and when it
finds a letter "X" in a row, it will automatically create a new tab and name

I have a column of dates. I want to find the cell which contains the date
1/1/2003. The code I tried is:
   Set Foundcell = Range("A:A").Find(What:="1/1/2003")
Unfortunately, because the dates are in reverse chronological order, the Find

I have created a simple function and for some reason the function doesn't
auto update.  I have tried Application.Volatile, and Sheet1.Calculate but for
some reason when I change the formatting on the cell it still doesn't update
the return value.

I have a macro that prints all worksheets.  Now I'd like it to print all
sheets that have a light blue color on their tab only.  Can you help me with
that IF statement?
Thanks much!

I found a question and I am also interested on the answer at below:
http://spreadsheets.google.com/pub?key=pGps8w5C-mxaVYe_4H6tOCQ
Anyone that can help?

I'm sure my problem is not that difficult but it seems unique as my
searches haven't come up with anything similar.  I have an excel file,
test1.xls and I want to take sheet2 specifically and export it into C:
and call the file that contains it test1.csv.  In the module, I have

I'm new to VBA and could use some help. I'm trying to have a macro
perform the same function (paste a rectangle) across several selected
sheets (say, 1-4,7,9,10 of 10). I can get the macro to paste the
rectangle across ALL the sheets, but I only want it on those selected.