Sheet Change Event-Get Sheet Name

[nigelk]

Hi all,

I have a workbook that has, on a daily basis, an unknown number of sheets.

Because of this I'm using the sheet change event in "This Workbook" to detect any changes in any sheet (except the overview sheet) in Cell A1

Is it possible to get name of the sheet in which the cell value has changed?
I can't use "Activesheet.Name", because that won't be the active sheet.


Thanks,Nigel

 

[Jonmo1]

It should be

sh.Name

 

[Richard Schollar]

Hi Nigel

One of the arguments to this SheetChange sub is Sh so the sheet name is simply:

MsgBox Sh.Name

 

[nigelk]

Don't worry, solved it with Target.Parent.Name

Thanks,Nigel

 

[nigelk]

Thanks for your replies, I didn't expect to get an answer so quickly!

Now I have two methods!

Nigel.