+ Reply to Thread
Results 1 to 4 of 4

LOOP in VBA

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question LOOP in VBA

    Hi all, I'm totally new into VBA. I need to Loop a task from row to row ( about 99 rows). I get some sample Loop code from internet however it seem like din't works for me, anyone here can help me looks at the coding below for the Loop? Thanks alot



    Please Login or Register  to view this content.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: LOOP in VBA

    So this code is just going to do the same thing 100 times.

    What do you want this part of the code to do?

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    04-14-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: LOOP in VBA

    Hi crooza, thanks for your reply.

    Actually for this task i need to get external data from internet then import it in certain cells. I had done that part already but for now i need to repeat it in different rows. Each row will have different data. I attach my excel file here for better understanding. Thanks alot

    https://drive.google.com/open?id=0Bz...2RCdFhCMkg5TEk

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: LOOP in VBA

    If you have to loop, you might use something like

    Please Login or Register  to view this content.
    Or it could be done without looping

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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] Auto email loop with formatted table data breaking on second loop VBA
    By Who_else in forum Excel General
    Replies: 6
    Last Post: 03-24-2016, 06:22 AM
  2. [SOLVED] VBA to loop within a loop of multiple blocks of data (currentregion) ... Expert needed
    By Jim885 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2016, 08:28 PM
  3. Find function in nested loop breaking down - not on first time through loop
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 04:59 PM
  4. HOW TO: Pause loop, fix error on a popup UserForm, continue loop
    By AndyMachin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-19-2014, 04:37 PM
  5. [SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)
    By nixon72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2013, 12:46 PM
  6. Why did an inner loop variable start overwriting the outer loop range suddenly?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 03:24 PM
  7. Replies: 0
    Last Post: 07-20-2010, 11:42 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