I have a workboo that contains 13 worksheets, I want to rename all sheets
beginning with Mar 07, April 07 etc.  I have forgotten how to do this without
renaming individually.  Can anyone help?  Thanks

how can I pull out numbers from a string?like:
aa012985  to  012985
12ab-059    to  12059
the letters or characters might be either at the first, middle or at the end

When I try to open Excel workbooks, worksheets, spreadsheets, or any of my
Office Documents associated with Excel from shortcut, my pc, search, browser,
exlorer, etc, Excelwill start but does not open file.  All I get is a blank
window (not a wkspc) within the Excel program.  To ...

I receive the following error message when closing an Excel file when one of
its unhidden worksheets is active, but not the other:
Run-time error '1004'
Select method of Range class failed

I would like to insert an United States Map in mi excel sheet

-- Hi.
I would like to be able to set up excel 2003 with the following features.  I
would like people to be able to enter data into the spreadsheet, but not be
allowed to change anything when it is entered.  

Hi everyone i just needed some help on a summing function.  On one side i
have two horizontal rows. The first being dated seperated on a week by week
format for about 148 weeks.  Under this row is another with a small numerical
value.  In another place is a set of 12 larger ...

I need a formula that looks says any cell that does not contain a "-",
"0" or blank will now equal the number in column B.
Any takers?
Dave

I'm not sure if this is possible, but basically what I'm trying to do is
protect a worksheet but still allow the users to click on the locked cells to
see a formula.  
I've got that to work ok, but I want to know, is it possible for them to

I almost never found out how to type in special characters on my laptop, so
I'll pass this along in case others are having the same problem.  At least,
this is the way it works on my Dell laptop.
1.  Press and release the NumLock key to turn NumLock on

I have a column of numbers in A, and I want B1=average(A1:A10) ,
B2=average(A11:A20), B3=average(A21:30)..........................
Is there any way to do this calculation? I can not input each equation
in column B, since I have lots of data.

I have workbooks with several spreadsheets, about 200mb to 300mb in file
sizes.  I can save changes while working with any workbook, and can close the
workbook if the size is under about 200mb.  Workbooks above about 200mb
cannot be closed, and Excel becomes unresponsive.  What ...

I was wondering if there is any way to pull both the data and the
formatting when using an if function? Assuming there is not, any help
me with the VBA code to do such? Thanks.

I have a form where it would be most convenient for the user to be able to
fill it out in a certain order.
Is there a way, when either "Tab", "Enter" is hit the cursor will move to a
specific cell?

Ok, I finally got a formula/format to work for subtracting my date/time
columns and my total minutes column on my main sheet1.  On another sheet
within my workbook I calculate different information that I get from my main
sheet.