+ Reply to Thread
Results 1 to 5 of 5

For next loop question.

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,019

    For next loop question.

    Greetings,
    Following code is okey;
    Please Login or Register  to view this content.
    Following code is not okey;
    Please Login or Register  to view this content.
    Please help.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,019

    Re: For next loop question.

    Solved.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: For next loop question.

    Please Login or Register  to view this content.
    produces a long while the second one produces a range.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,234

    Re: For next loop question.

    What module is your code in? If it is not in the module for Sheet1, then maybe you need this:

    Please Login or Register  to view this content.
    By the way--yes your code has a For loop but your question is not about the For loop, it's about referencing the last row on a sheet.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: For next loop question.

    This will return an array.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. [SOLVED] Loop within a Loop Question
    By vexel77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 11:26 AM
  2. Loop Question
    By ej463 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2009, 02:18 AM
  3. For Next Loop Question
    By GregR in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-27-2006, 11:00 AM
  4. Loop question
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-13-2005, 06:05 PM
  5. For...Next Loop question
    By CWatsonJr in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-12-2005, 04:26 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