Trying to get value of cell above a table header

[sspatriots]

Hi,

If my table header looks like the following:

Range("G2JobList[[Job" & Chr(10) & "Status]]")

How could I use this sort of header reference to get the value of the cell that is directly above this table header (which is not part of the table)? Trying to keep this code dynamic by referencing everything off of the table name and headers.


Thanks, SS

 

[bebo021999]

How about:

Range("G2JobList[[Job" & Chr(10) & "Status]]").offset(-1,0).value

 

[sspatriots]

I tried that using Debug and got nothing.

 

[sspatriots]

Somehow I managed to get it to work with going up two rows. It was trying to use the header itself by going up just the one row. Weird.

Range("G2JobList[[Job" & Chr(10) & "Status]]").offset(-2,0).value