vb novice

in my code currently, i am using (1,3) format for cell ref in things like
Offset, etc.
What i would like to do is have the column not be based on a number, but the
header text in row 5.

in other word when b8 is active cell then the offset would be (0, and
whatever column contains "Invoice #" in header row 5.