In a normal module, any unqualified range reference - e.g. just Range("A1") - will refer to A1 on the active sheet of the active workbook. That is the same no matter which workbook the code is in, so I'm not sure I really see it as an issue. I cannot see any benefit to moving code that should apply to a specific sheet in a specific workbook into another workbook.