Automatically Insert Titles to New Sheet

Right now I have a program which exports data to excel. Every time this program exports a new dataset, it automatically creates a new sheet in excel. I want each new sheet that is automatically created to have the same titles in the first row (the data starts in the second row). So far I haven't had any luck. Any help would be appreciated. Thanks.

OK I tried entering that code and excel does indeed appear to be running it because the first time I tried it it made me change my security settings for macros. But still not luck - the new sheets being created do not have the titles I specified in the first row of cells. I'm stuck.

I used exactly what you gave me just to see if it would work. Disclaimer: I know almost nothing about macros or VB.

I used exactly what you gave me just to see if it would work. Disclaimer: I know almost nothing about macros or VB.

Possibly you did not put the code in the correct module.
The code must be pasted into the module named "ThisWorkbook"

Right-click the Excel icon next to "File" in the menu bar and select "View Code". The VBE will open up and that module will be the active module.

In the code window, paste in the entire bit of code.
Close the VBE.

If it still doesn't work, then you'll need to answer the question about how the new worksheets are created.

At the worst, you can run a macro manually to enter the values for the header. This code assumes the newly added worksheet is the activesheet.
It must be placed into a "Standard Module".

Please Login or Register  to view this content.