Loop through range problem

**Cicada** · 10-15-2018, 08:03 PM

Hello I am able to execute the below code if I place an url next to ie.navigate in parentheses. I would like however be able to loop through a collection of hyperlinks I have in column A of sheet 1 and execute the code for each hyperlink and for the results to be displyed in column A of sheet 2. I have fiddled around and keep getting errors. Any help would be great. Cheers

Please Login or Register  to view this content.

**AB33** · 10-16-2018, 04:40 AM

Assiming the URL does not require any adjsutments– it is the same URL which starts in row 2 in sheet 1.

Please Login or Register  to view this content.

**Cicada** · 10-25-2018, 10:51 AM

Thank you AB much appreciated. Haven't tested it as yet will see how it goes. Cheers.

Dan

**Cicada** · 10-25-2018, 10:05 PM

Hello AB

The code works fine and performs the desired task though I am experiencing memory issues and lag. Thanks for your help with this.
I have posted a new thread with tweaked code to deal with new issue. (not sure if I should have done it here). Again thanks for
for taking the time.

Regards
Daniel

Loop through range problem

LinkBack

Thread Tools

Rate This Thread

Display

Loop through range problem

Re: Loop through range problem

Re: Loop through range problem

Re: Loop through range problem

Thread Information

Users Browsing this Thread

Similar Threads

Problem loop another non continious range to other sheet

[SOLVED] Double 'For Each Cell' loop range problem

Dynamic Range Paste Problem within a Loop of spreadsheets in a directory - Excel 2013

Problem using loop for sending excel range in email body using Range to HTML code

Loop and range problem

problem with Range statement in With-End With loop

Problem adding charts using Do-Loop Until loop

Bookmarks

Bookmarks

Posting Permissions