If you use the Workbook_SheetDeactivate workbook event, sh gives you the
sheet you are leaving.

--
HTH

Bob Phillips

"Graham Haughs" wrote in message
...
Bob Phillips wrote:
Are you thinking activesheet is the sheet you are coming from or the one
you
are going to?

The activesheet is the one I am leaving.
Graham