This almost fixed my problem. It looks at the cell I would like but nowinstead of looking at the worksheet Ref. Tables that is in the sameworkbook it looks for a totally new workbook. Can we fix that problemtoo?