I am interesting in such question:
I have table with two types of cell formating, one with font 12 and one
with font 10. Is there a function to do something like this:
= IF (in target cell font is 12, result A)

I have a pivot table and sometimes it adds a "2" to the end of a row lable ie.
"joes pizza" is displayed as "joes pizza2".
the sorce data certanly doesn't include the "2" and it seems like it is
trying to tell me some thing ;). It might be hapening after i do a "replace

HYCH
Am using the code below, to pull back the a list of Times (format
hh:mm)
But still shows as decimal numbers

I'm trapping the App_workbookbefore Print Event which is working
wonderfully!
See http://www.cpearson.com/excel/AppEvent.aspx
But The Question I've got is it possible to return what sheet, if only

I have a problem where my spreadsheet is taking most of my CPU.  I'm
interested in any tips or pointers on how to go about troubleshooting
this.
This is what I have:

Is there any way in Excel to determine the Windows environment variable
%userprofile%? I need to write a macro to update templates on various
machines and need this information.
I can copy the "update" workbook to "My Documents" using %userprofile% in a

I have a report that I've exported from Access into Excel.  There are approx.
5 columns and over 1400 rows.  Each column represents a month, and each row
represents a customer.  Some months are blank, which I'd like to
automatically have formatted to read zero.  I need to create ...

i have created (or designed) an excel doc that tracks purchasing for
my projects. what i am trying to do is track how much is spent per
month
in one tab, i have all purchases consolidated .. which cotain the

I am using vlookup to return values (lets say values A-I) based on other
values (Values 1-10) in column A.
Sometimes there is no value in column A and I'd like vlookup to return a
value "blank cell" or whatever I define.

I'm working on this worksheet and you folks have been wonderful in your
help.
Sometimes I accept your help without question but this time I need further
explanation..

I'm working in Excel 2003 SP2, and I'm trying to replace all
references to named ranges used within my formulas within a workbook
with the underlying absolute cell references. I found a solution in
the archives of this newsgroup (

I am in the process of writing an article about Excel add-ins/
applications and I was wondering if I could pick your brains.
So...If anyone uses/wrote/knows a good Excel Add-in or an Excel
related software please drop me a link.

HYCH.
The code below works for what i want, BUT !!
In the worksheet "Lists" i want the 1st combobox to show the values as
hh:mm but am getting the display as decimal, where do i format the

for excel 2003, the formula
=IF(FIND("s",A2:A14),B2,IF(FIND("s",A2:A14),C2,0)) will fail ( show #VALUE
as result) when s is not present but "r" is.
what can one do about that?

Can someone please tell me  how to create a poster on excel version 2003?
Thanks