Hi everyone.
I'm going down an array (named range "Labor", 10 wide x 20 long) and pulling values out to another sheet. There are column headers that aren't part of the named range sitting on the row above the first row of range Labor. Simply, what's the syntax to refer to them?
In other words, I need to know how to get the value sitting in the row above the first member in range Labor.
Looks like this, for example, and the headers aren't part of the named range that begins at "2" and ends at "7".
Blue Red Yellow
2 1 6
4 4 9
3 8 7
The solution needs to be able to work regardless of where the Labor range sits in a sheet.
Thanks y'all.
I'm going down an array (named range "Labor", 10 wide x 20 long) and pulling values out to another sheet. There are column headers that aren't part of the named range sitting on the row above the first row of range Labor. Simply, what's the syntax to refer to them?
In other words, I need to know how to get the value sitting in the row above the first member in range Labor.
Looks like this, for example, and the headers aren't part of the named range that begins at "2" and ends at "7".
Blue Red Yellow
2 1 6
4 4 9
3 8 7
The solution needs to be able to work regardless of where the Labor range sits in a sheet.
Thanks y'all.