Dear friends,
you can use this code as well
ActiveSheet.Name = Application.WorksheetFunction.Text(Now, "dd-")
regards
Sudheer
(sudheer...@gmail.com
On Mon, Jul 11, 2011 at 7:21 PM, Prabhu wrote:
> Thanks Ashish,
>
> Regards,
>
> Prabhu
>
> --
>
> ---
Thanks Ashish,
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/g
ActiveSheet.Name = Day(Now) & "-" & Application.WorksheetFunction.Text(Now,
"")
On Mon, Jul 11, 2011 at 5:22 PM, Prabhu wrote:
> Hi,
>
> Is it possible to rename the active sheet with current date&month.Current
> date must be the date when i run the macro.
>
> Example if i run the macro on
