I am looking for a way to add the first row of my workbook to every worksheet I create. Currently Worksheet one contains the the text that I would like to automatically be added to worksheet 2, etc, even if I create a new worksheet, I would like that text added to the new worksheet.
I have attached a copy of the file to this post. Any info would be greatly appreciated.
1) Copy this code.
2) Right-Click the sheet tab
3) Select "View Code"
4) Double-click the "ThisWorkbook" object in the project explorer
5) Paste the code into the window that appears.
6) Save the file as a macro-enabled .xlsm file.
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 05-13-2016 at 10:16 AM.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks