Can you post your code and maybe someone can help.
--
HTH,
Barb Reinhardt



"Emma" wrote:

Need to create macro in excel to use in different workbooks and it seems that
when I recorded the macro it was only looking at the current workbook. How
do I create it so that it run on all workbooks?