Got around to taking another look at this today and I've cracked it! I
placed a COUNTIF formula (value 0) in a cell outside the range and then used
this value in an OFFSET to select the cell with the last date when the sheet
is opened. Hope this might be of help to others.
--
pignick


"pignick" wrote:

I have a workbook containing a number of worksheets, some of which contain
weekly data extracted from a database and which are regularly updated, and
others perform various calculations on the data to produce reports and
graphs.

After updating the data I want to be able to visually check the latest week
of data entry in one of the worksheets, and am trying to write a macro that
will place the cursor on the first cell of the row containing the most recent
date (i.e. maximum date value) when the sheet is opened rather than having to
scroll down through an increasingly long column each time.

I have tried several things without success - I am new to macro writing -
can anyone help with a suggestion please? Thanks in anticipation.
--
pignick