Re #1, You CAN sort a worksheet that isn't active. Please post the code you
have.

Re #2, see www.cpearson.com for help with identifying background colors. BTW,
if the color is a result of conditional formatting, you can't determine what
it is by VBA code. You would have to see which of the conditional formatting
conditions is met.

On Sat, 23 Oct 2004 17:58:09 -0700, "kim" wrote:

1. I have a hiden worksheet that I would like to sort. So far, I am only
able to get the macro to work if I make the worksheet active in order to
sort. I need to keep the sheet hidden. Is there a way to sort a hidden
worksheet?

2. In my spreadsheet I have certain rows that are colored in background RED.
I would like to use the IF in a cell to say something like "IF A1=background
in RED, A1+2, A1*2". Is it possible?

Thanks
Kim