Posted to microsoft.public.excel.programming

Little Penny[_3_] Little Penny[_3_] is offline

external usenet poster

Posts: 48

Rename active sheet

I'm looking for a macro that will take the last used cell with a value
in column A and E. Combine the two values and rename the active sheet.
Colum A is formatted for text. Colum E is formatted for the date and
time.( m-d-yy h-mmAM/PM;@")

Example:

A E
Cedarhurst 8-3-07 9-00AM

Should rename the active sheet (Cedarhurst 8-3-07 9-00AM)

Thanks

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
Rename active sheet with current file name	[email protected]	Excel Programming	5	July 11th 06 11:29 AM
using VBA to rename active sheet	Papa Jonah	Excel Programming	5	October 22nd 04 02:38 PM
Rename active sheet	lumaduc	Excel Programming	1	June 3rd 04 08:46 PM
Rename active sheet	Ginny[_2_]	Excel Programming	2	January 9th 04 10:59 PM
Rename Active Sheet	Jason[_25_]	Excel Programming	2	September 21st 03 02:03 AM

All times are GMT +1. The time now is 06:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us