• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Join Worksheet function & VBA function

Junarkar

Member
Hi,

I use below code to get Sheet Name;

Range("K1").Value = Split(ActiveSheet.Name, "_")(0)
Example Result - APS

And below code to in cell A1;

WorksheetName = "=CONCATENATE(""GC - "",Text(Today(),""MMMM DD""),"" - "",K1)"
Example Result - GC-July 07 - APS

Rather than taking the first result to Cell K1 and then use it in Concatenate function, is there a way to combine both formulas?

I want to know just out of curiosity and to learn more about VBA.

Regards
Junarkar
 
Top