Color a range

[khansen97]

I am trying to color a range. I cannot figure out the code to define my range.

I want it to be

Row = rnum
column A to W (or 1 to 23)

I know the syntax is activeworksheet.range("RANGE")..Interior.Color = RGB(211, 211, 211)


But I don't know how to put my range in the "RANGE" variable.

Can anybody help?

 

[SkipVought]

Hi,

Row = rnum
column A to W (or 1 to 23)

with activeworksheet
  .range(.Cells(rnum, "A"), .Cells(rnum, "W")).Interior.Color = RGB(211, 211, 211)
end with

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[PHV]

Something like this ?
ActiveWorksheet.Range("A" & rnum & ":W" & rnum).Interior.Color = RGB(211, 211, 211)


Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[khansen97]

Both ideas worked!!

Thank you sooo much!