MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Active cell showing sheet.

Posted by Mike on August 04, 2000 3:09 AM

I recently asked for help and I got a swift response (thanks Ada).

The code below is what I wanted.


I'm now wondering if there is a way that on another cell it will tell me what Sheet is active.

So if sheet2 Cell A1 has text then the code above will show what's in that cell. But I want to show in another cell that Sheet2 is the active sheet.

Is this possible.


Posted by Ivan Moala on August 04, 0100 3:33 AM

Just change your formula slightly