not sure if that works if i'm in the open companion workbook whenthe macro is run. sorry if i'm not explaining this too well.