Determining End User Actions

[rayd8]

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

 

[Tom Ogilvy]

Look at Chip Pearson's page no this topic.

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

 

[Jim Thomlinson]

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.

 

[rayd8]

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