Results 1 to 25 of 25

VBA Looping of Excel Macros

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2015
    Location
    New York
    MS-Off Ver
    2305 - Enterprise 365
    Posts
    162

    VBA Looping of Excel Macros

    Hello All,
    I would like to create a loop within a public sub using the attached workbook. Would provide some VBA coding for the following scenario? The following is not really code, just parameters:

    Sub  Copy_and_Paste_of_Active_Cells_below_current_Selection
      1. Go to Worksheet "Data Dumpster & Cruncher"
      2. If entire rows have not already been selected, select Entire rows that are active starting with row 1 through the row before the next blank row (in the attached, that means rows 1 through 70). 
       2a.  Or if entire rows HAVE been selected, go to the next series of rows that are active after the next blank row (in the attached, that means rows 72 through 149).
       2a. If there are no more active rows below current selection, end macro with MsgBox "FINISHED!"
    
       3. Run Macro "String_of_Macros_Strung_Together"
       4. Run Macro "Copy_Time_Sheet"
       5. Loop back to Step 1.
    
    End Sub

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-09-2015, 09:30 PM
  2. ODD occurence with looping macros
    By mattmickle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2015, 04:36 PM
  3. Excel Document with Macros or Access file with Macros
    By jcchs2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2015, 01:21 PM
  4. [SOLVED] Looping macros to add text to beginning and end of a paragraph
    By shanew in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2009, 05:26 AM
  5. [SOLVED] Calling macros, looping function? Can this code be written more efficiently?
    By Punsterr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-07-2005, 03:05 PM
  6. Help needed - seriously (looping? macros? formulas?)
    By jarski in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2005, 01:05 PM
  7. Looping macros using VB code
    By accessuser1308 in forum Excel General
    Replies: 2
    Last Post: 03-09-2005, 08: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