Activating Desired Sheet

[Russell007]

Hi,

I created a code in which it will add a new SHEET and rename it based on a textbox and move it before a sheet with name "MACRO".
My question is, how can I activate the New Sheet Created dynamically without using the Sheet Name?

 

[Skyybot]

Use a With statement.

 

[Peter_SSs]

Welcome to the MrExcel board!

Normally, when you add a worksheet via code, that sheet automatically becomes the active sheet. If that is not the case for you, then perhaps we should see your whole code that includes adding this new sheet.
When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details.

Is the textbox on a UserForm or is it on a worksheet?

 

[Russell007]

Welcome to the MrExcel board!

Normally, when you add a worksheet via code, that sheet automatically becomes the active sheet. If that is not the case for you, then perhaps we should see your whole code that includes adding this new sheet.
When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details.

Is the textbox on a UserForm or is it on a worksheet?

It's actually on a worksheet but I'll move it in a User Form afterwards.
- I'm copy pasting some formulas in "FORMULA" Sheet going to the newly added sheet but every time the code will go to the "FORMULA" sheet it will be activated and paste the formula on that same Sheet. What I wanted is copy the formula from "FORMULA" sheet and paste it on my desired sheet without referencing that Sheet because it will change monthly.

 

[Peter_SSs]

So ..

.. then perhaps we should see your whole code that includes adding this new sheet.

 

[Russell007]

Worksheets(ActiveSheet.Index - 2).Select

Thank you I have resolved it using this code.

 

[Peter_SSs]

Thanks for letting us know.