It should have read the other way around, sorry. Your source sheet is Sheet2.
Just change the sheetname in the expression to: Sheet2!$A$1, and you can
use/propagate it easily in Sheet1.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---