]Ok now if I copy and Add it created a new workbook not the current on im in. What am I doing wrong?
Please Login or Register to view this content.
]Ok now if I copy and Add it created a new workbook not the current on im in. What am I doing wrong?
Please Login or Register to view this content.
Last edited by Dragonruler12; 11-25-2008 at 04:14 PM.
Change ACtiveWorkbook to ThisWorkbook throughout.
What are you tring to do?
Entia non sunt multiplicanda sine necessitate
Ok I did change it like you said however it still copies/creates a new workbook with name Set-up Standard with Two sheets named the way i want them to be. What am I missing?
Sorry bout that added this before I read your post.
I am trying to copy a "Standard" Sheet and rename it however I can never be sure what sheet number it is and I want the two tabs to be named what the label2.Caption is and Label4.Caption is.
Please Login or Register to view this content.
Still not sure what you want. Maybe this?
Please Login or Register to view this content.
I believe we got a weiner.... LOL ^_^ thanks you got what I wanted to do. I knew it had to been syntax error or something with a little bit of a change..... Thanks for all the support guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks