range("test").Range("A1").Row

--


Gary


"Asif" wrote in message
...
I need to refer to top row of named range.

.Value = Range("col_CP")(0, 0) _
.Offset(WorksheetFunction.Match("Client", Range("col_CP"), 0), 2)

I'm getting Runtime error 1004: Method 'Range' of object '_Worksheet' failed

I'd appreciate if somebody could help me getting this code right.

--
Thanx & regards,
Asif