I have a worksheet that calls a procedure to format every other row wit
gray for readability. However if an end user sorts the worksheet tha
formatting gets all screwed up. Is there any way to determine an en
user's actions on a worksheet such as performing a sort?

I thought maybe a work around would be the SheetChange or the Chang
Event to look for a change to the worksheet and then call the forma
row procedure again.

This doesn't seem like the best solution. Can anyone suggest a bette
way

--
rayd
-----------------------------------------------------------------------
rayd8's Profile: http://www.excelforum.com/member.php...fo&userid=2626
View this thread: http://www.excelforum.com/showthread.php?threadid=39917

Look at Chip Pearson's page no this topic.

http://www.cpearson.com/excel/banding.htm

--
Regards,
Tom Ogilvy


"rayd8" wrote in
message ...

I have a worksheet that calls a procedure to format every other row with
gray for readability. However if an end user sorts the worksheet that
formatting gets all screwed up. Is there any way to determine an end
user's actions on a worksheet such as performing a sort?

I thought maybe a work around would be the SheetChange or the Change
Event to look for a change to the worksheet and then call the format
row procedure again.

This doesn't seem like the best solution. Can anyone suggest a better
way?


--
rayd8
------------------------------------------------------------------------
rayd8's Profile:
http://www.excelforum.com/member.php...o&userid=26267
View this thread: http://www.excelforum.com/showthread...hreadid=399175

You would be better off with a conditional format that reference the row
number and highlights all oof the odd rows Gray... Use the following formula

=MOD(ROW(), 2)

in the formula for the conditional formatting.
--
HTH...

Jim Thomlinson


"rayd8" wrote:


I have a worksheet that calls a procedure to format every other row with
gray for readability. However if an end user sorts the worksheet that
formatting gets all screwed up. Is there any way to determine an end
user's actions on a worksheet such as performing a sort?

I thought maybe a work around would be the SheetChange or the Change
Event to look for a change to the worksheet and then call the format
row procedure again.

This doesn't seem like the best solution. Can anyone suggest a better
way?


--
rayd8
------------------------------------------------------------------------
rayd8's Profile: http://www.excelforum.com/member.php...o&userid=26267
View this thread: http://www.excelforum.com/showthread...hreadid=399175

Hmmm.... Thanks for the replies I am going to have to investigate you
recommendations. I haven't used formulas in VBA code before so I've go
some studying to do.

I liked my VBA procedure because it only formats the range tha
contains data. The spreadsheet with the VBA code creates anothe
workbook and then imports and formats a text file so I never know th
range of the data.

Thanks for the tip

--
rayd
-----------------------------------------------------------------------
rayd8's Profile: http://www.excelforum.com/member.php...fo&userid=2626
View this thread: http://www.excelforum.com/showthread.php?threadid=39917