Peo,

=ADDRESS(COLUMN(),ROW(),4)

In my XL97 it says to have the ROW() and COLUMN() the other way round ie

=ADDRESS(ROW(),COLUMN(),4)

Am I missing something?

--
Regards,

Sandy

Replace@mailinator with @tiscali.co.uk