I have a main sheet followed by 15 tabs
I want to copy paste as values say D10 to E11 in each item tab
The normal VB code is to activate each tab and wirte the code
Is there anyway I can loop and write a code such that the copy paste as values is performed in each tab one after the other.The 15 tabs could be mentioned in the main sheet in a range for example A1 to A15
Please help me out with this
if you want paste on all Sheets you don't need list of them
Please Login or Register to view this content.
Last edited by patel45; 04-29-2013 at 02:53 AM.
If solved remember to mark Thread as solved
Hi, patel45,
Copy will not paste values but fill in formulas.Originally Posted by rshnkmr39
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks