=ADDRESS(ROW(B6),COLUMN(A5))
--
David Biddulph

"James shaw" wrote in message
...

Hi i wonder if you can help,

if i have a column starting with say A5, and have a row, could say
starting with B6.... how do i get excel to find the intersection of the
row and the column?... ie to find the cell A6?

Your help would be much much much appreciated,

James




--
James shaw