Re: Code to Color ActiveRow Columns A Through C

From: Ron de Bruin (rondebruin_at_kabelfoon.nl)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 21:33:14 +0100

Hi J.E

For this example you can use it
Most people have problems with offset/resize ...

That's why I posted it as a alternative 

-- 
Regards Ron de Bruin
(Win XP Pro SP-1  XL2000-2003)
www.rondebruin.nl
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message news:jemcgimpsey-8DE5D7.13091503032004@msnews.microsoft.com...
> But you do introduce two things I don't like:
>
> 1) Using A1 references as indexes In this case it doesn't really matter
> as much  because you're starting in column 1, but I tend get confused
> when I seethings like  Cells(ActiveCell.Row, 23).Range("A1:C4"). I
> prefer to think of A1 as always being at the top left corner of the
> work***, period.
>
> 2) Having to resolve the range reference. Resize is very fast compared
> to resolving a string references (though I'm not sure whether the
> compiler resolves it on the first pass or not).
>
> Mostly just personal preference.
>
> In article <ub4peNVAEHA.3828@TK2MSFTNGP10.phx.gbl>,
>  "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote:
>
> > You don't have to count the columns then<g>