Thanks for all three proposals guys, they work OK!
For the Format/Auto Format..., I was not at all aware of this option until
now, learned something new :-)

"Dave Peterson" wrote in message
...
You may want to glimpse at Format|autoformat, too.

If you like one, you could record a macro while you do it manually.
Remember to
click that Options button to use the settings you like.

markx wrote:

Hello everybody,

Do you know how to highlight every second row withing the
ActiveCell.CurrentRegion area with a macro (not conditional formatting)?

Thanks for your help!
Regards,
Mark

--

Dave Peterson