On 28 Mar, 09:51, "Mikey C" wrote:
Sorry for the late reply, but thanks very much :-)

Just one more question ...

I have used the following formula
=HYPERLINK("#"&CELL("address",Contacts!A1027:G1054 ),"target")

The reason I tried to use a range of cells is because I want the
entire 'record' to display in the users view. However, if the Contacts
page is left in position above the required record (from the previous
viewing / save), only the title will show and the user will have to
scroll down to find the details. It has the opposite affect if I
select the last cell of the record - I hope that description made some
sense to you!!

Do you know how I can adjust the link to make it show an area / range
of cells to make it always apear squarely in the users screen?