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.

.