C Chip Pearson Oct 28, 2003 #2 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)
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)
R Ron de Bruin Oct 28, 2003 #3 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
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
