Macro creating new worksheet and connecting table to newly created worksheet

[pilonb6050]

I want to create a macro that creates a new worksheet based on a filled out template, clears the template for future use, and then adds the information to a larger table (on the first worksheet) by referencing the newly created worksheet. The problem I am having is that the macro will work the first time, but then instead of adding information to the larger table based on the newly created worksheet, it will pull from the worksheet that was created the first time. Any help is greatly appreciated! Thank you!

[excelgirl84]

hello, I did not test this code but maybe this can help?
To make sure your macro always references the correct worksheet, you will need to fully qualify the worksheet references in your code. This means that, whenever you reference a worksheet or range in your code, you should include the workbook and worksheet name, as well as the cell or range reference. For example, instead of using Range("A1"), you would use something like ThisWorkbook.Worksheets("Sheet1").Range("A1"). This tells Excel to use the range "A1" on the "Sheet1" worksheet in the active workbook.

Another approach you could use is to create a variable to store a reference to the new worksheet. You could then use this variable throughout your code to reference the correct worksheet. For example:

Please Login or Register  to view this content.

By using a variable to store the reference to the new worksheet, you can avoid any confusion about which worksheet your code is referencing.

[TMS]

This tells Excel to use the range "A1" on the "Sheet1" worksheet in the active workbook.

Strictly speaking, this tells Excel to use the range "A1" on the "Sheet1" worksheet in the workbook with the code in it, which may, or may not, be the active workbook.