View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WINDMILL WINDMILL is offline
external usenet poster
 
Posts: 8
Default how to return the value of the last nonblank cell in a row?

Does anyone know of a method to return the value of the last nonblank cell in
a row?
I have a running total spreadsheet that contains links to other workers, the
value that I need in the reference cell has to be the last value in the row,
it may be b22 then next time c22, d22 etc
all suggestions appreciated.