+ Reply to Thread
Results 1 to 2 of 2

Code and button is in sheet 8, would like to alter code to run from sheet 13. Thanks,

  1. #1
    Registered User
    Join Date
    01-25-2004
    Posts
    13

    Code and button is in sheet 8, would like to alter code to run from sheet 13. Thanks,

    Sub Button1_Update()


    Range("E2").Value = Range("E2").Value + Range("N2").Value
    Range("E3").Value = Range("E3").Value + Range("N3").Value
    Range("E4").Value = Range("E4").Value + Range("N4").Value
    Range("E5").Value = Range("E5").Value + Range("N5").Value
    Range("E6").Value = Range("E6").Value + Range("N6").Value
    Range("E7").Value = Range("E7").Value + Range("N7").Value
    Range("E8").Value = Range("E8").Value + Range("N8").Value
    Range("E9").Value = Range("E9").Value + Range("N9").Value
    Range("E10").Value = Range("E10").Value + Range("N10").Value
    Range("E11").Value = Range("E11").Value + Range("N11").Value
    Range("E12").Value = Range("E12").Value + Range("N12").Value
    Range("E13").Value = Range("E13").Value + Range("N13").Value
    Range("E14").Value = Range("E14").Value + Range("N14").Value
    Range("E15").Value = Range("E15").Value + Range("N15").Value
    Range("E16").Value = Range("E16").Value + Range("N16").Value
    Range("E17").Value = Range("E17").Value + Range("N17").Value
    Range("E18").Value = Range("E18").Value + Range("N18").Value
    Range("E19").Value = Range("E19").Value + Range("N19").Value
    Range("E20").Value = Range("E20").Value + Range("N20").Value
    Range("E21").Value = Range("E21").Value + Range("N21").Value
    Range("E22").Value = Range("E22").Value + Range("N22").Value
    Range("E23").Value = Range("E23").Value + Range("N23").Value
    Range("E24").Value = Range("E24").Value + Range("N24").Value
    Range("E25").Value = Range("E25").Value + Range("N25").Value
    Range("E26").Value = Range("E26").Value + Range("N26").Value
    Range("E27").Value = Range("E27").Value + Range("N27").Value
    Range("E28").Value = Range("E28").Value + Range("N28").Value
    Range("E29").Value = Range("E29").Value + Range("N29").Value



    End Sub

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Code and button is in sheet 8, would like to alter code to run from sheet 13. Thanks,

    Since your code doesn't reference a worksheet, it will run on the worksheet that has the button. Just copy the button to whatever sheet you want the code to run on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-16-2023, 01:03 PM
  2. Alter code for only first sheet
    By bosco2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-26-2015, 03:12 PM
  3. code for button to print a sheet
    By gk_1605 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 01:16 PM
  4. Trying to Give New Command Button Code from Another Sheet's Code
    By MegaRush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2012, 09:43 AM
  5. running sheet code with a button
    By mark-ainsworth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2011, 12:59 PM
  6. Code Under Button Not Recongnizing New Sheet When Copying
    By SEOT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-16-2008, 11:16 PM
  7. [SOLVED] Code for opening another sheet on button click
    By pmud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2005, 06:06 PM

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