"Chip Pearson" wrote in message
...
(...) unqualified range references "roll
up" through that particular sheet, not the ActiveSheet.
(...)
Change your code to
Sheets("Forecast").Select
Sheets("Forecast").Range("A1").Select

Philosophy question: I never touch remote sheets from sheet modules, find that impossible
to overview and maintain. Maybe it's just my own non-standard way of organizing things.
Thoughts on this anyone ?


Best wishes Harald
Followup to newsgroup only please.