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!