LinkBack URL
About LinkBacks
Hi,
Can anyone help me to simplfy this code using Array set & loop. I have to create copy for 20 worksheets
here is the sample of 4 worksheets
Please Login or Register to view this content.
Hi,
Can anyone help me to simplfy this code using Array set & loop. I have to create copy for 20 worksheets
here is the sample of 4 worksheets
Please Login or Register to view this content.
can u please provide full code with sample workbook...
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi Naveed,
The full code is too long and involves too many function. I thought just to simplfy this code.
e.g. From Sheets("ANNEXURE 1 (i)").Select, create copy of 4 worksheets & rename it
Try replacing your provided code with this below one and confirm me
Please Login or Register to view this content.
Hi Naveed,
Thanks a lot
Glad I could help you
1. If the suggestion helps you, then Click * to Add Reputation
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi Naveed,
Are you familiar with update link from excel to power point? to create VBA code for it,
Appreciate if you could help me
http://www.excelforum.com/excel-prog...wer-point.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks