This one worked if the macro is in the same workbook. how would youdo it if the info is in a different workbook.