Thanks for the response Frank, but I was hoping to be able to do this
with a worsheet function, rather than with VBA?



Frank Kabel wrote:

Hi
try something like

with worksheets("other sheet")
msgbox .Cells(Rows.count, "A").End(xlUp).value
end with


-----Original Message-----
I have data stored on a sheet that I want to access from

another sheet.

The data is stored in rows with a varying number of

data items on each

row. Is there a worksheet formula to return the value in

the last

occupied cell on the row?

Any help would be appreciated.

.