Results 1 to 6 of 6

Macro modification required (very small)

Threaded View

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

    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...

    Sub EnterFormula()
    With Sheets("i6")  ' here i want to add more sheet like (i7,i8,i9,i10,i11,i12,i13,i14,i15)
    .Range("AB6").Formula = "=IF(COUNT(BD6:BL6)=0,"""",SUM(BD6:BL6)/9)"  ' in every sheet need to put same formula 
    End With
    End Sub
    Last edited by nur2544; 12-21-2012 at 04:41 AM.

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