View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrius B. Andrius B. is offline
external usenet poster
 
Posts: 4
Default Last Used Cell in a row??

Hi.
I hope someone could help me this time, too.

I need to find the last used cell (that is, not empty, contains some data)
in a Row and to get the column number, witch contains that cell.

E.G. such rows


person1 | 4556 | | 4564 | | |
person2 | www | | | | dddddd |

So, if I specify a row number 1, the code should return "4", and for the
second row - "6".

I have tried many examples from Internet, but they return either the first
column or number "256"...

Any ideas?