+ Reply to Thread
Results 1 to 5 of 5

Excel VBA - Condense multiple variable transfer code

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Globe, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    19

    Excel VBA - Condense multiple variable transfer code

    Hi, I would like some help to condense this please, it works but…
    1- I would like to see it done cleaner and better, I’ve tried to no avail
    2- And because I have nine other worksheets to add to the code

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Isacc; 11-29-2012 at 01:50 PM. Reason: to wrap code text, per rule #3

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,629

    Re: Excel VBA - Condense multiple variable transfer code

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    Globe, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Excel VBA - Condense multiple variable transfer code

    Thank you, i have corrected my original post

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Excel VBA - Condense multiple variable transfer code

    hi Isaac, option, press Roll Up button
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-28-2012
    Location
    Globe, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Excel VBA - Condense multiple variable transfer code

    Interesting! Very clean, short and to the point… definitely not the direction I was heading, Thanks Watersev! I still feel like a newborn with this stuff.

+ 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