Dear all,
How to add same formula in different sheet ? below macro is running fine for the sheet "i6" very well.
but now i want to add more sheet like (i7,i8,i9,i10,i11,i12,i13,i14,i15) so that when ever i run macro
each & every sheet having same formula at a time. here one things i can create sheet wise macro
but it makes the the overall macro bigger & also size is factor. i need your assistance...
Please Login or Register to view this content.
Last edited by nur2544; 12-21-2012 at 04:41 AM.
First create/insert a code module in your VBA project and copy & paste the following code in that module
Please Login or Register to view this content.
Hello nur2544,
Or you could change your code to:
Also see the "Please consider" note at the bottom of this post.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi,Olaf.Braxhoofden
Wonderful logic. Thanks.
Hi,Winon
Excellent..Thanks.
Hello nur2544,
You are welcome.
Glad we could help.
Thank you for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks