Referring first row in range
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.
|