Is it possible to access the add-in Microsoft Office Icon Gallery for use of
the icons on the QAT in Excel?  If so, can you please help me with the
proceedure?
Thank you.

I've created 5 Pivot Tables using one database.  I've setup column widths and
font formats.  I've unchecked the Autofit Col Widths and checked the Preserve
Formatting boxes PT Options, Layout & Format.
On all 5 of the PT's, when I edit a record or add a new record, and then

I don't want to see that word (blank) scattered throughout my Pivot Table.
So, while in a PT Worksheet, I select the Excel Replace feature and in the
Find What box I type (blank) and in the Replace With box I put two spaces.  
That works in getting rid of the word (blank) ...

I go to the top of my excel page and can find insert; however, I cannot find
name>define. Where do I need to look. I have 2007 version.
Sincerely,
Robin

Using the Loop example from Excel Help -
For Each c In Worksheets("Sheet1").Range("A1:D10").Cells
       If Abs(c.Value) < 0.01 Then c.Value = 0
   Next

I would like to permanently save page margins, orientation, and gridline
selections so every time I open a new excel worksheet, it will be formatted
for optimal printing. thanks.

Userform "Customer Orderform"  "ComboBox1" I would like to click the arrow,
scroll down find and click on name filling the form with the remaining
customer info that resides in an inactive workbook.  The active workbook is
"WorkorderMLTestBK"

Hello, I have a about 1000 cells in a worksheet that are hyperlinked.  The
hyperlink path changed on all to a file path that is not recognized.  How do
I change the hyperlink to the correct file path without going into to each
cell and editing the path?  The path is the same for ...

I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.
How do I distinguish between the two in an IF statement?
Thanks,

I'm trying to open a group of files from a list starting at D5 on the Menu
worksheet.
Following is the code i have tried.
sub open_files()

im tired of writing long and detailed questions so i can get answers, and
have 'service temporarily unavailable' or  'error occured while sending your
post'
its rediculous.  i had to try 8 times just to open this one, and had to

im looking to conditionally format a column of numbers to show the 'largest
but not greater than' value in comparison to another cell.  that 'largest but
not greater than value' i'd like to change its colour.
the adjacent column, i'd like to format the same as the one adjacent to

What I have:
A sheet that is named all containing 40 columns of information.  Every day
or two new information is added to the next row.  Column 40 contains the
names Bill, Joe, Ted, Frank, Steve.

I'm comparing quarterly volume in a pivot table (I brought in the values and  
am showing them as "difference from" the prior quarter).  I have many rows
with no Q/Q change and would like to filter them out, but when I filter the
rows selecting a value filter with "difference" <>0 ...

I want to write a macro to copy down “Holiday” in column A until the row
where “Vacation” appears.  And then copy down “Vacation” in the subsequent
rows. And the in column B, I want to copy down “Team A” until the next team
is mentioned.  However, I don’t want the macro applied ...