It's in different sheet, Data. The named range is N31:N45. I want to pick the
value from column O.

--
Thanx & regards,
Asif


"Alan Beban" wrote:

What is the address of Range("col_cp")?

Alan Beban

Asif wrote:
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.