My company recently upgraded to Excel 2003, SP2. I created a spreadsheet for
a co-worker with some example formulas and gave her instructions on how to
copy the formulas to the correct locations on a new spreadsheet she would
create.

I want to look at a range of  cells and find "AGT".
When a cell containing "AGT" is found I want to Highlite it in yellow.
The below code doesn't find all the cells.
I have bumped intCount up to 1000 and this is no help.

I am using MsgBox for promts, and the font is too small for what I want
to do; but I haven't been able to find a way to enlarge it short of changing
my screen resolution.  Am I missing something that should be obvious?

In Word we can change to uppercase by selecting the text then clicking
Shift+F3. What's the equivalent in Excel ??
Many thanks in advance.

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

I am trying to match information in multiple columns (lookup value) to
the same multiple columns in the table array.  If the combinations
don't match then I'd like the return to be #N/A.  I think an example
can better clarify what I'm trying to accomplish because I haven't a

I haven’t posted many needs but have learned so much from everyone, fro
just reading various requests for help. A forum like this in my opinio
should be used to set the standard for all that will follow. I jus
want to thank everyone for the time they spend helping others expan

i want to make a presentation box that is linked with drop down menu i mean
when i choose any thing in the drop down menu its shows the details in the
presentation box. Please help

I am self employed and every week I fill out invoices, and sometimes get
comfused what invoice number I need to use.
what I would like to do  is every time I open my work sheet is to have a
auto invoice number for every time how do I do it, please be has clear and

On my mobile phone bill if I have
£240.43 pounds of calls left in a month free of charges
How do I find out how many minutes I have instead of pound, left
for every call I make, each call is charged a 20 pence

I have a set of cells that show the fraction of #complete/#total.  They
are formatted as fractions so that I can custom format them such that
those >=50% turn green and those <50% turn red.  The problem is that
for a completion of, say 8/12, excel automatically simplifies to 2/3.

I've never had this happen before so I'm not sure anything can be
done.
This file has worked fine for weeks.  I work on it from my USB flash
drive.  First indication of trouble was yesterday.  I couldn't save it

Dim x
x = Application.CountIf("E5,E6000", "T13065")
How do I fix this so I don't get an "Error 2015"
Thanks, Rick

I used the formula below, given elsewhere on this site to convert kilos into
Stones & Pounds.
=INT(CONVERT(F6,"kg","lbm")/14)&"st "&MOD(CONVERT(F6,"kg","lbm")/14,1)
*14&"lb"  When I converted 98 kilos I got the following result 15st 6.

How do I create multipal hyperlink inside the text box.