I think the proper reference should be [Sales$].

I have a separate question. Is it also [sheetname$] for Excel 2007? I have it working in Excel 2003 but in...