+ Reply to Thread
Results 1 to 28 of 28

Loop for vba macro from a specific column to the last column with data

Hybrid View

lcgar Loop for vba macro from a... 10-06-2016, 07:12 AM
StephenR Re: Loop for vba macro from a... 10-06-2016, 07:31 AM
lcgar Re: Loop for vba macro from a... 10-06-2016, 08:31 AM
StephenR Re: Loop for vba macro from a... 10-06-2016, 08:39 AM
lcgar Re: Loop for vba macro from a... 10-06-2016, 09:03 AM
StephenR Re: Loop for vba macro from a... 10-06-2016, 09:44 AM
lcgar Re: Loop for vba macro from a... 10-06-2016, 09:50 AM
lcgar Re: Loop for vba macro from a... 10-06-2016, 10:04 AM
StephenR Re: Loop for vba macro from a... 10-06-2016, 10:05 AM
lcgar Re: Loop for vba macro from a... 10-06-2016, 10:33 AM
StephenR Re: Loop for vba macro from a... 10-06-2016, 11:51 AM
lcgar Re: Loop for vba macro from a... 10-06-2016, 12:07 PM
StephenR Re: Loop for vba macro from a... 10-06-2016, 12:03 PM
lcgar Re: Loop for vba macro from a... 10-07-2016, 04:53 AM
StephenR Re: Loop for vba macro from a... 10-07-2016, 05:49 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 07:57 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 08:12 AM
StephenR Re: Loop for vba macro from a... 10-07-2016, 08:16 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 09:18 AM
StephenR Re: Loop for vba macro from a... 10-07-2016, 09:21 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 09:26 AM
StephenR Re: Loop for vba macro from a... 10-07-2016, 09:50 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 10:15 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 10:24 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 10:27 AM
StephenR Re: Loop for vba macro from a... 10-07-2016, 10:31 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 11:39 AM
lcgar Re: Loop for vba macro from a... 10-07-2016, 11:41 AM
  1. #1
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Loop for vba macro from a specific column to the last column with data

    I think so. One thing - if the start month is 7 does that mean the numbers should only start from March 2017 (the 7th month across)?

  2. #2
    Registered User
    Join Date
    09-28-2016
    Location
    Paris
    MS-Off Ver
    2010
    Posts
    26

    Re: Loop for vba macro from a specific column to the last column with data

    Quote Originally Posted by StephenR View Post
    I think so. One thing - if the start month is 7 does that mean the numbers should only start from March 2017 (the 7th month across)?
    This is just a random number I typed to test the macro. It's a variable itself and corresponds to the starting point. Let's say that the first non-zero value in each column is the first month whose number is the number of that cell.

    Example 1: Number 7 --> july -->column N
    Example 2: Number 10---> october --> column E

    I know it's a bit confusing, but I think it simplifies the process, after all....

    Thank you again for the selfless effort you're making.

+ 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. loop through range to copy row if data exists in column, then delete the column
    By wpryan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2015, 05:03 PM
  2. [SOLVED] Loop through Column B for Specific value
    By GFOREMAN in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-10-2014, 08:42 PM
  3. [SOLVED] Copy/Paste Macro Loop For A column of Data
    By brooksbil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2012, 02:31 PM
  4. Replies: 6
    Last Post: 02-28-2012, 07:49 AM
  5. Loop Macro to Find Minimum Date for Column Data
    By abpexcelforum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2011, 05:03 PM
  6. Replies: 1
    Last Post: 05-06-2011, 03:08 AM
  7. Macro Loop to Extract Specific Values and Min/Max Values From Column/Rows Range
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-19-2010, 09:19 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