I'm trying to find the cell address of the first non-empty cell in a row.

This formula gives me the the position within the range of the first non
empty cell but not the cell address

=MATCH(TRUE,H16:AB16<"",0)

it simply returns and interger such as 4 when the fourth cell in the range
is the first non empty cell.

somehow I need to take that and convert it into a cell address

Thanks,

--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003