See my code example Paul

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Paul Sheppard" wrote in message
news:Paul.Sheppard.1t56yj_1122995111.0628@excelfor um-nospam.com...

Bryan Hessey Wrote:
=INDIRECT("sheet"&ROW()&"!A1")
and formula-drag down the column for 130 rows

Brian

Thanks for this, this only seems to work if the worksheets are called
sheet1 sheet2 etc, how does this need to change if the sheets have
different names?


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=392061