Hi
i have a worksheet that allows the user to enter data over a range
C27 : Z27
What i want to do is check the range and return the last cell that
contains a value
i have tried several formulas but am getting lost
this formula below is the closest i can get to resolving the problem

=ADDRESS(ROW(A5),MATCH(<>" ",A5:E5))


can anyone help please

thanks

kevin