Check activate sheet

[efi]

Hi,
In which command can I check which sheet is activate at the moment?

thanx.

 

[Chip Pearson]

Efi,

ActiveSheet will always refer to the sheet that is presently active. E.g.,

MsgBox "Active Sheet: " & ActiveSheet.Name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Ron de Bruin]

MsgBox ActiveSheet.Name
This will give you the name

With this you can run code if the sheet Mysheet is active

If ActiveSheet.Name = "Mysheet" Then
'your code
End If