VBA New Tab Help

[RandyLWalkerJr]

Hi all,

I’m having trouble with a VBA that I am trying to write and would really appreciate some help.

I want to write a macro that essentially copies the current page in its entirety, transfers it to a new tab, and then allows me to make a few adjustments in the new tab that has just been created. I want to be able to do this for an infinite number of tabs, so that the new tab is always a copy from the one right before it.


Can anyone please help? I’m desperate for some help.


Thanks in advance.

 

[Kaper]

Sub MakeSheetCopyAfterCurrent()
ActiveSheet.Copy After:=ActiveSheet
End Sub

shall do excatly as needed: make a copy of the current sheet in current workbook, place it just behind the current one and make it active.

 

[RandyLWalkerJr]

Awesome. Will give it a go right now. Can't thank you enough

 

[RandyLWalkerJr]

If I just wanted to add that line of code into my current VBA, how do I do that? When I try to take out the words "sub" and "end sub", the lines become red.

Thanks.

 

[Kaper]

As you already have some code (registered?), it is already surronded by sub/end sub
insert only

ActiveSheet.Copy After:=ActiveSheet</pre>

in new line in this place in your code, where you want copying to be executed.

 

[RandyLWalkerJr]

I'm still running into trouble. The macro that I'm trying to create ultimately copies the current tab I am on, copies it over to a new tab, and then makes adjustments on the new tab.

Right now, it is working only for othe first page, but once I try to execute the macro from pages 2-3, I am running into problems. Does anyone know why this could be?