Assuming the activecell is B7, then

=OFFSET(B7,-ROW(B7)+1,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ABCBAC" wrote in message
oups.com...
Dear all,

How can my formulas return collum heading of specific current cell

Thanks for help
Bac