If you define the worksheet properly .. e.g.

ThisworkBook.Sheets("SheetName").Range("what_ever_ range)

It will work irrespective of where you are writing the code, Worksheet code,
ThisWorkBook code or, Module code.

Sharad


"Peter Chatterton" wrote in message
om...
Hope this isn't too terse, but "my macro can't form a Range on an
inactive Worksheet" seems to cover it. It's Excel 2002 on XP. Hope
you can help, I'm baffled. Peter.