A better description of what you want would be helpful. You speak of
column "G4", but the columns are identified by one or two letter over
the range of A through IV.

What do you want to look up in the "last cell?" Do you want its value?

I suspect you want to find the first column where there is data in the
4th row, and to then retrieve the data from the cell in the first row of
that column. Is my guess correct?

If you want to find the last column in any row that is non zero, the
general procedure is to go all the way to the right (make row IV the
active cell) and then come back to the first entry using the equivalent
of control-left.


Greg B wrote:
I am currently writing a spreadsheet where i put numbers across a page and
they are in columns 1 to 14.

I want a code to look up the last used cell on column "g4" for example

and give me the corresponding cell on g1

I am not sure on how to word this. Hope this is clear enough

Thanks in advance

Greg