Thread: HIGHLIGHTING ROWS & COLUMNS
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
  
Posts: 90
Default HIGHLIGHTING ROWS & COLUMNS
Dim oRng As Range
Set oRng = Union(Columns(sCol), Rows(iRow))
oRng.Select

To be further anal, you can also replace the above with
Union(Columns(sCol), Rows(iRow)).Select

But nice code :)
Reply With QuoteReply With Quote