I have a macro that will create a worksheet with today's date then the macro will copy and paste info to that worksheet. Now my problem is that when trying to copy it says it cannot find the name of the worksheet....Does anyone know a code that will always activate the newly created worksheet?
Anyone?
It is default for new created worksheet to be the activesheet ...
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
I need to see the code to see the problem. As Yasser states the newly created sheet would be the active sheet, so we would need to see your code. Please state on which line the error occurs.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks