+ Reply to Thread
Results 1 to 7 of 7

Button code to change offset cell in different sheet

  1. #1
    Registered User
    Join Date
    05-16-2016
    Location
    Philippines
    MS-Off Ver
    excel
    Posts
    40

    Button code to change offset cell in different sheet

    Any can help me simplify this code thanks. sorry newbie

    I am trying to change the offset file in every cell using a button, but i have bunch off sheet to use to. And my code is so long and having hard time to scroll it down.

    Thank you.

    Please Login or Register  to view this content.
    Last edited by 23inzane10; 05-17-2016 at 01:43 AM. Reason: admin ask because its against forum rules

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: macro help simplify

    23inzane10 welcome to the forum

    Thanks for the change

    Can you explain what you are trying to do - and why do you need VBA for this?
    Last edited by FDibbins; 05-17-2016 at 01:55 AM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: macro help simplify

    Taken back and waiting for Thread Title Change
    Last edited by :) Sixthsense :); 05-17-2016 at 12:44 AM.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: macro help simplify

    Works for me.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-16-2016
    Location
    Philippines
    MS-Off Ver
    excel
    Posts
    40

    Re: Button code to change offset cell in different sheet

    thanks bakerman2 it really helps a lot.

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Button code to change offset cell in different sheet

    You're welcome.
    For your interest, shortened version.
    Please Login or Register  to view this content.

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Button code to change offset cell in different sheet

    Thanks 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)

Similar Threads

  1. Want to simplify my Macro
    By Hamjea1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-10-2016, 04:03 PM
  2. How to simplify this macro
    By aneshdas in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-14-2014, 01:11 AM
  3. I need macro/ vba help to simplify a report
    By sjoseph in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-02-2013, 03:30 PM
  4. Simplify macro
    By iamasimpleman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2011, 07:01 AM
  5. How do I simplify this macro?
    By snooze24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2009, 04:47 PM
  6. Simplify the Macro of Looping
    By ccl28 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2006, 05:20 AM
  7. Simplify a macro
    By Einar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2005, 05:05 AM

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