I'm running Excel 2003 SP3 and when I open an Excel attachment via my
Outlook it pops up an error message saying "The system cannot find the
file specified".  If I save the document to my desktop then double
click on the document it opens up Excel but not the document.  Once

It's amazing how much time can be wasted trying variations of a custom
formula in Data Validation without hitting on the right syntax  :-(
I have a cell (assume A1) formatted as a number to 2 decimal places.
Normally a formula will enter the appropriate number in the cell, ...

Another stupid inquiry from me, this time regarding conditional
formatting.
I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four

I have a workbook with 4 pages, is it possible to password protect just one
sheet to prevent it being opened.
Thanks

I have tried everything. I did a mail merge in Excel and cannot seem to
remove the extra space between the first and last name in the address block
on the letter when no middle initial is available.
My data fields are FirstName, MiddleInitial, LastName and some people do not

Please could I beg a little advice from the experts here
I'm using the following code to export data without quotation marks to text
files.
Sub Export()

I had Excel develop a 6th order polynomial regression with Dates (M/D/Y) as
the independent variable (x) and Hydraulic Flow as the dependant variable
(y). Unfortunately, when I try to use the equation to generate Hydraulic Flow
values the equation outputs extremely large numbers ...

I have the following macro to set chart fonts to arial 10.
But If I apply this macro to a chart that already has fonts colored
differently (lets say some are red, some blue, some white) it changes
all fonts to black. I tried to remove ColorIndex hoping i would than

Excel 2007 sp1 with vista 32 business sp1
Background: When you highlight multiple non-contigious cells (i.e. hold the
control key down and select several cells that are not connected) Excel
highlights the selected cells in light blue.

I've got a macro that currently prompts the user to open a .CSV file.
The command I use for this is:
FName = Application.GetOpenFilename("Excel Files (*.csv),*.csv")
This command only displays .CSV files in the "open" window that's

Whenever I record a new macro to my personal macro workbook it works OK
and I can see that a new module has been created ok when in the VBA
editor, but when I exit excel and re-open the macro doesn't work and the
module has disappeared?

Before I ask my question I just want to thank you all in this group
for your amazing helpfulness... I'd be so lost without this group!
Thank you all!
Now onto business...

I have posted a file at:
https://filesanywhere.com
I can enter cell referances in the arguments for the index function and it
will return the value in the intersecting cell, but when I enter the values

I am creating a spreadsheet and one column will have a date established  and
another column will have a follow-up date, which will be three weeks from
established date. Is there a formula to change the follow-up date every three
weeks and can it stop changing when the word ...

I've been asked to oversee the implementation of a process where
organisations would send us sensitive client data via password protected
Excel workbooks (i.e. the workbook would have the password on it, not the
sheets contained therein.