This topic posted in the Microsoft forum should push you into the right direction:
http://forums.microsoft.com/MSDN/Sho...75068&SiteID=1
Please note after reading the topic that if your sheets are numbered with numbers e.g. 1, 2 3 that you use ['1$'] to identify the sheet. and not [1$]
- Tsadok