I use XP's Silver scheme. Why do some Office 2007 apps use a BLUE color
scheme while others like (Publisher) use the right scheme (XP Silver). It
looks horrible and contrasts with everything. Why the disparity?!!!

I want to do what I think is an advanced search and replace and I don't know
how to do it.  In column a I have a variety of phrases.  In column b, c, d,
etc. I have a variety f sentences (each column has exactly the same
sentences).  Each sentence has one phrase in common ...

I'm trying to Auto-Filter in Excel 2007.  It's terrible! What did they do to
it?
In previous versions of excel, you would autofilter a column, then when
selecting the dropdown you just choose what you want to filter.  Now it

If  I have two columns of numbers:
1  50
2  40
1  20

Tom  3
Bob  4
Ed    2
Jane 1

Can someone tell me how to find the Report Wizard (or what I need to do to install it)?
TIA

Cell A1   50
Cell A2  100
I would like to subtract the two cells, with only the positive number
appearing

Could someone please help with a macro or any other suggestion to
format an
Excel sheet. Basically data is downloaded from a bank every week and
the

As noted in a previous post, I'm trying to replace as much of the
.Select processing as I can in the code in my current app
Here's what I'm doing now:
-----------------------------

I have an Excel spreadsheet someone emailed me. I am not able to open it for
some reason. I have WinXP. Excel 2002 or 2003. My Temp Internet files are
empty. So are my %TEMP% files. Their version is recent as well.This is the
second time the email has been sent to me. No error ...

I have an Excel sheet with a specific range of cells that contain numbers.
The format of these cells is "General" (so not "Number").
The numbers in these cells use dots (e.g. 4.2) while I work with commas
(e.g. 4,2). Does anyone know how can I convert the numbers into numbers that

This works - but I know now that it's bad practice:
----------------------------------------------------------------------
4002 Dim myCosmeticRange  As Excel.Range
5420 With theSS.Worksheets(theDataSheetName)

I collect data from a DDE link and my spreadsheet normally, and through most
of today, calculated at its normal fast speed. I made a minor change here
and there to some spreadsheets and suddenly noticed that my worksheets are
laboring in recalculations that go on continuously ...

I want to update AGE field in file A from file b.  i.e update AGE.
The number of records in file A and File B are not equal and may be
different value.
this is what i want

Need to be able to enter first several letters of a name and have the
dropdown pick them up as I type in the name.  Had it on a demo worksheet in
my "learn" files  BUT lost it somewhere.  Please refer me to where I can
pick up some samples to use..  Thank You..