I have written some code that allow me to display a rectangle around
certain scores within my worksheet. My code fomats the rectangle with
black lines if a specific condition is met and with transparent lines
if the condition is not met. My problem is I have about 50 rectangles

TIA. Rich.

I haven't worked with Excel for a number of years...
I have an Excel price list...all prices are reflecting my COST...
If there not a way to tell the entire column to display as "content o
cell x 2.5"?

I've got Excel 97 and a Kyocera 1020D printer.The printer is set to
automatic duplex. I've got 5 sheets in a workbook. Printing should put the
even sheets (2 & 4) on the back of pages 1 and 3 respectively.  Sheet 2
prints on the back of sheet 1, but sheet 4 fails to print on the ...

I would like to mark a cell using the IF like:
A                    B            C                D
Number    0 - 30        31 - 60    61 - 90
15                X

How do I make a drop list that is used with the cell-validation feature
depend on the selection from the drop list/cell validation of a
previously filled cell?
Example:  Cell A2 can be Hot, Warm, or Cold.  If Hot is selected, cell

Good day, I've asked this before but not well enough. I have a table that
looks like below:
date             deal             deal#           rep          amt
status

This may be easy...
I am adding hours by day (m-f) & totaling at the end of the wor
week... My total includes just the days (EX: =SUM(E6:K6)) But, here i
my question, I want to add to the same cell in adition to standar

I wrote a VB program that retrive data from SQL server to make a excel
report. The report has some static text, such as report header, report
footer, etc. Besides I need to set the font size of certains columns,
therefore, I cannot directly use the ADO recordset directly.

is there anyway using grouping i can do a sort ignoring the hidden rows?
example:
Rows hidden 1:12, 52:71, 111:130, 170:189, 229:236
Rows Visible 13:51, 72:110, 131:169, 190:228

If I select a collection of cells in a spreadsheet I frequently work with
and do a copy, I always get the error message "The picture is too large and
will be truncated". I do not understand that it is copying this as a
picture. I rund WinXP Prof. on a new Centrino Laptop with plenty ...

It seems that somehow I have "inherited" custom headers
and footers from someone else's workbook.  They have
filled up almost all the allocated spaces in the drop-down
selection list and pre-empt me from adding more than two

Hello again,
how can I dislpay some massage during run macro.
for example:
Sub Makro1()

Using Excel 2002
I have a list of data brought over from Access.  The list consists of
salespeople (names) in the "a" column and information related to individual
sales in the subsequent columns (Date, Tasks sold, total revenue, total

I would like value in a certain rage of cells to always be negativ
without adding minus sign when enter the value. Does anyone know how t
set this??? Many thanks
--