Setting row color with a VBA macro ...

Setting row color with a VBA macro ...

Hi, I'm trying to set the row color of the active cell with a VBA macro.

My code works, but the new row color is not visible unless I reload my spreadsheet. (Took me a bit to realize that.)

Here's the single line of code I'm using.

activecell.entirerow.interior.color = rgb(255,0,0)

I'm no VBA expert so maybe there's something obvious I'm doing wrong. Do I have to force a redraw or reload somehow?

thanks.