First you don't need address as you already have a range object.

rng1.Offset(l, k + 4).EntireRow

to get the whole row

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Nick London" wrote in message
...
I have a macro that first searches for a ceratin cell with some pre
specified
content. When finding that cell it then makes a list. I want to have the
entire row that cell that i found to have bold fonts or some other
adjustment. I then want to have every second row below the cell that I
found
to be gray or some other adjustment. Thus I need to know how how refer to
an
entire row. My code now is e.g. :

Range(rng1.Offset(l, k + 4).Address) = dblSumRelative

See I use the address of the cell that contains the pre defined info in
order to refer to other cells. This is becuse the address of the cell is
variable. Thus, how do you write:

Range(rng1.Offset(here I want to refer to row, k+4).Address).Select

Thanks!