+ Reply to Thread
Results 1 to 5 of 5

how do i loop through columns in same row?

  1. 07-02-2018, 03:57 PM #1
    kevinu
    kevinu is offline
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    how do i loop through columns in same row?

    Is it possible to loop through columns in an loop? I know how to loop rows but never tried columns

    Please Login or Register  to view this content.
    I was thinking this but all it does is make the range 'a1' through 'a8', I want it to go 'a1' to 'b1' and so on.
    Reply With QuoteRegister To Reply
  2. 07-02-2018, 04:02 PM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: how do i loop through columns in same row?

    You may try ( NOT TESTED )
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 07-02-2018, 04:32 PM #3
    kevinu
    kevinu is offline
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    Re: how do i loop through columns in same row?

    not sure how to implement that. Here is what i want to happen but with a loop if possible.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 07-02-2018, 05:03 PM #4
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: how do i loop through columns in same row? 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  5. 07-02-2018, 05:48 PM #5
    kevinu
    kevinu is offline
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    Re: how do i loop through columns in same row?

    that works great thanks
    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. Looking for a macro to move 2 columns over creating an advancing loop (total 30 columns)
    By clundeen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2017, 12:53 PM
  2. [SOLVED] Sort columns B,C,D based on column B then loop to next 3 columns and repeat till last colu
    By Andy15 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-09-2017, 05:35 PM
  3. [SOLVED] Loop through a userform listbox & copy certain columns into txtboxes on userform loop next
    By mtilbury in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2016, 10:10 AM
  4. [SOLVED] Macro to select columns, call a macro, then shift 11 columns and run again in loop
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2016, 12:24 PM
  5. Loop Across Columns...If Blank Cell, Loop Down Rows
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2014, 07:05 PM
  6. Loop Across Columns If Blank Cell Loop Down Rows
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 10:22 AM
  7. loop through columns in range and only copy columns that have value of 0
    By gherzberg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2012, 12:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1