+ Reply to Thread
Results 1 to 7 of 7

How to convert a lengthy vba code into short and concise code with the help of loop

  1. 01-27-2023, 03:26 PM #1
    Khanzaki
    Khanzaki is offline
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    How to convert a lengthy vba code into short and concise code with the help of loop

    Hi all
    I would like to get the below code shortened with the help of loops or any other method possible

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-28-2023, 01:16 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: How to convert a lengthy vba code into short and concise code with the help of loop

    Please see yellow banner on how to attach a sample workbook.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 01-29-2023, 03:35 AM #3
    k1dr0ck
    k1dr0ck is offline
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: How to convert a lengthy vba code into short and concise code with the help of loop

    just an idea , untested

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 02-02-2023, 02:02 AM #4
    Khanzaki
    Khanzaki is offline
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: How to convert a lengthy vba code into short and concise code with the help of loop

    Dear Sir k1dr0ck ,
    Your code is not just an idea it's an invention .. simply brilliant !Couldn't ask for anything more !
    Thankyou so very much You solved my problem .
    I have another code which I will be uploading in a while hoping it to be shortened too !
    Thanks again.
    Reply With QuoteRegister To Reply
  5. 02-02-2023, 02:04 AM #5
    Khanzaki
    Khanzaki is offline
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: How to convert a lengthy vba code into short and concise code with the help of loop

    can this code be shortened too like the previous one
    Please Login or Register  to view this content.
    Last edited by Khanzaki; 02-02-2023 at 03:09 AM.
    Reply With QuoteRegister To Reply
  6. 02-02-2023, 04:27 AM #6
    k1dr0ck
    k1dr0ck is offline
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: How to convert a lengthy vba code into short and concise code with the help of loop

    try

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 02-05-2023, 11:36 AM #7
    Khanzaki
    Khanzaki is offline
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: How to convert a lengthy vba code into short and concise code with the help of loop

    Hi k1dr0ck ,
    You solved my query Thankyou so much !
    This forum and its contributors rock! Seriously !!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert short VBA code to google sheet Json
    By tagazou in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2020, 07:44 AM
  2. [SOLVED] Required vba code for serial no. Short code +series no of combobox value
    By sbvaram in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2020, 06:38 AM
  3. [SOLVED] Modify code vba is more concise
    By tax112 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-11-2019, 09:46 AM
  4. Creating more concise code to speed up macro runtime
    By Shyatt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2017, 01:48 AM
  5. How to simplify lengthy vba code
    By soldeerbout in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2016, 10:10 AM
  6. short a long code with loop
    By Mamud in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-04-2014, 05:16 PM
  7. Shorten a lengthy code
    By Pyro Form in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-27-2012, 04:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1