+ Reply to Thread
Results 1 to 6 of 6

Macro modification required (very small)

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Macro modification required (very small)

    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.

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Macro modification required (very small)

    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.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Macro modification required (very small)

    Hello nur2544,

    Or you could change your code to:

    Please Login or Register  to view this content.
    Also see the "Please consider" note at the bottom of this post.
    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] .

  4. #4
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Macro modification required (very small)

    Hi,Olaf.Braxhoofden

    Wonderful logic. Thanks.

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Macro modification required (very small)

    Hi,Winon
    Excellent..Thanks.

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Macro modification required (very small)

    Hello nur2544,

    You are welcome.

    Glad we could help.

    Thank you for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1