I am trying to recode the macro below so that the subject line shows "Email about - (Tab name of the active worksheet)"
Please Login or Register to view this content.
I am trying to recode the macro below so that the subject line shows "Email about - (Tab name of the active worksheet)"
Please Login or Register to view this content.
Last edited by dagindi; 07-19-2010 at 10:49 PM.
Maybe
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
returns name of current sheet.Please Login or Register to view this content.
You can browse through all sheets in a workbook as follows:-
hthPlease Login or Register to view this content.
Ajay
Please Login or Register to view this content.
Thanks to all for a job well done and another lesson learned.
Cheers!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Roy,
This thread was marked SOLVED 8 hours prior to your message.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks