what Event is triggered when user adds/deletes rows?

I'm trying to create VBA conditional formatting (more than 4 formats needed).

One of my formats involves alternating row colors, e.g.:

Please Login or Register  to view this content.

If the user inserts or deletes rows, then I'll have to update everything below the change. For which Worksheet Event should I be writing code and what range will it pass to my subroutine so that I know where to work the changes?

Unless you're using Excel 2007, Excel will map whatever RGB color you specify to the nearest color on the 56-color palette. Use instead,

Please Login or Register  to view this content.

Let me make sure I understand you. If the user deletes a row, the Worksheet_Change Event will pass me the first non-deleted row below that, correct?

Then is there any way for a Worksheet_Chage subroutine to tell that a row was deleted? I mean, how can my code distinguish the deleted-row case from a case where the user pasted over all the values in a given row?

ps. thanks for the RGB tip. Is there a quick way to tell which ColorIndex goes to which color? I mean besides writing code to test each one.

Here -- you can make a wall chart suitable for hanging ...

Put this in the Worksheet module; it checks for deleted rows, columns, and random ranges. Skip the cases you don't want, and add whatever processing you want in lieu of what's there.

Please Login or Register  to view this content.