Range representing a single row of a named range

Hi guys,

I have a named range called "DATA" in a worksheet (its about 100rows x 20cols) and I'm trying to write some code to return a range that represents a single row of range("DATA") based upon the active cell. However I don't want EntireRow.

To do this I'm using Worksheet_SelectionChange(ByVal Target As Range) event and I've used the Intersect function to test that Target is in Range("DATA").

Then for example:

Imagine Range("DATA") is C10:V110. When I select K43 ie Target is K43, I want the range C43:V43 to be returned to a variable in VBA.

How can I do this?

Thanks in advance

Jonny

Thanks guys,

You've solved my problem. Here's what I was trying to do...underline active row of range DATA with a medium weight border.

Please Login or Register  to view this content.