tourless
Board Regular
- Joined
- Feb 8, 2007
- Messages
- 140
- Office Version
- 365
- Platform
- Windows
Hi Folks,
I have a vlookup that's failing to return anything and I think it's because my named range has a header row. Is there are way to name a range based on row 2 to the last row for columns A & B? Right now I have...
.
thanks.
I have a vlookup that's failing to return anything and I think it's because my named range has a header row. Is there are way to name a range based on row 2 to the last row for columns A & B? Right now I have...
Code:
sheet.names.Add Name:="MyName", RefersToR1C1=:"='sheet'!C1:C2"
thanks.