+ Reply to Thread
Results 1 to 2 of 2

VBA Copy Data Code help for active sheet

  1. #1
    Registered User
    Join Date
    09-24-2019
    Location
    Orange County, CA
    MS-Off Ver
    Office 365
    Posts
    2

    VBA Copy Data Code help for active sheet

    I have a workbook with about 50 sheets in it. All have the same format and layout. Each have a button and in field A1 of each sheet is where the below needs to reference. When I started building this i had created a code for each sheet individiually and now have 50 which is causing my workbook to act up. How can I change the code to be just "Current Sheet"A1 & A9 and then assign the 1 code to each sheets button. So for instance the below where it has sheet44 would just need to be current sheet Sheet 3 will always be the same. Any help on this would be much appreciated!!

    Please Login or Register  to view this content.
    Last edited by cherisem; 09-27-2019 at 02:17 PM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,483

    Re: VBA Copy Data Code help for active sheet

    Hi there,

    This is just a knee-jerk (and untested) suggestion, but see if the following code does what you need:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

+ 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. [SOLVED] Code to display text & code in a combo list, but display only code when selected
    By kdestef1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2019, 06:07 PM
  2. [SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.
    By FragaGeddon in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-30-2015, 11:46 AM
  3. [SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2015, 03:05 PM
  4. [SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.
    By Heinrich Venter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2014, 06:10 AM
  5. [SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table
    By cteaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 08:01 PM
  6. Replies: 2
    Last Post: 03-09-2013, 04:30 AM

Tags for this Thread

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