Posted to microsoft.public.excel.programming

rasta

external usenet poster

Posts: 1

name of the activesheet

there are 3 worksheets, named:
worksheet_A
worksheet_B
worksheet_C

in cell B2 for each sheet, how can i display the name of the corresponding
sheet? if the name of the sheet changes so should the contents of B2.

so cell B2 on worksheet_A, will show: "worksheet_A"

thank you.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't get ActiveSheet to work...	[email protected]	Excel Discussion (Misc queries)	2	August 16th 07 06:12 PM
ActiveSheet.Name?	Andrew Stedman	Excel Programming	5	July 30th 03 01:17 PM
ActiveSheet	Graham[_3_]	Excel Programming	0	July 30th 03 09:08 AM
ActiveSheet	Ron de Bruin	Excel Programming	0	July 29th 03 04:59 PM
ActiveSheet	Graham[_3_]	Excel Programming	0	July 29th 03 04:47 PM

All times are GMT +1. The time now is 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us