Hi this macro work not well:
the name this Sheets(ShtName).Select is ShtName = Range("F1").Value '<<< name sheet in cell F1
Please Login or Register to view this content.
but non work.
In F1 there is a data validation for the choice of the sheet
A help?
max
Last edited by AliGW; 02-10-2019 at 09:09 AM.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi bakerman.
Your macro work well.
I made a change and added a password:
but mistake paste specialPlease Login or Register to view this content.
here : Sheets(ShtName).Range("A2").PasteSpecial xlPasteValues
attach a esemle.
max
Please Login or Register to view this content.
Hi bakerman.
error paste special here class range
With Sheets(ShtName)
.Unprotect "987654"
.Range("A2").PasteSpecial xlPasteValues
Application.Goto .Range("A2")
.Protect "987654"
End With
Works just fine in your example file so something else must be in play here ?
The title I think it's right now
Last edited by max_max; 02-10-2019 at 08:13 AM.
No, it isn't - sorry. Look, I will do it for you this time, but really, I should not have to. You need to do better than this in future.
Last edited by AliGW; 02-10-2019 at 09:11 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi bakerman2.
I change your macro so:
it seems to me to workPlease Login or Register to view this content.
max
As I said earlier, all works fine in your example file but if these modifcations work for you the better.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks