Dear Friends,
I need to copy values from current sheet and paste values in the NEXT VISIBLE SHEET. Further, NEXT VISIBLE SHEET to be made active.
Related points are:
There are some sheets kept hidden.
Therefore, the values to be pasted ONLY in the NEXT VISIBLE SHEET.
I have attached a sample file for your kind ref.
Please help me to resolve.
Good friends are hard to find, harder to leave, and impossible to forget.
acsishere.
Try:
I assumed that you wanted to copy the ranges to only the first visible sheet.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Great! Great!! Great!!!.
Excellent & exactly done. Thanks a lot Sir.
You are very welcome.
Sir, an additional request. The above code is working nicely.
But, I forgot to tell you that the sheet is protected with a password "aaa".
Therefore, once copied from Main Sheet and then it should be pasted after opening the next visible sheet using password “aaa” and paste the values in the specified cells. Then once again protect with the same password.
Pl help me Sir.
Try this.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks