Copy and Paste Tab

[AmyCrowder]

Hi all,

I am relatively new to VBA and am trying to learn it's limitations.

I have managed to create a user form that creates a new tab with the name entered in the user form text box.

On this new tab, is there a way using VBA to have it equal to the values and formatting of an other tab at the time when the new tab was created?

I don't want this information to update as the original tab does. In essence I am saving the work done on the original tab to a new tab, each time I make a change.

Please let me know if this can be done, or if you need any more information!

Thanks,

Amy

 

[GTO]

Greetings Amy,

Without seeing how you are setting reference to the newly created worksheet, by simply example:

<font face=Courier New><SPAN style="color:#00007F">Option</SPAN> <SPAN style="color:#00007F">Explicit</SPAN><br>  <br><SPAN style="color:#00007F">Sub</SPAN> example()<br><SPAN style="color:#00007F">Dim</SPAN> ws <SPAN style="color:#00007F">As</SPAN> Worksheet<br><SPAN style="color:#00007F">Dim</SPAN> rngSource <SPAN style="color:#00007F">As</SPAN> Range<br>  <br>  <br>  <SPAN style="color:#00007F">Set</SPAN> rngSource = ThisWorkbook.Worksheets("Sheet5").UsedRange<br>  <br>  <SPAN style="color:#00007F">Set</SPAN> ws = ThisWorkbook.Worksheets.Add(After:=ActiveSheet)<br>  <SPAN style="color:#00007F">With</SPAN> ws<br>    .Name = "Whatever name you chose"<br>    .Range("A1").Resize(rngSource.Rows.Count, rngSource.Columns.Count).Value = rngSource.Value<br>  <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br>  <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Does that help?

Mark