Loop Through Rows faster

**rollin** · 02-01-2018, 01:29 PM

Hi All,

I need help with my code to make it loop faster. I have this code in my Format Report routine. My report runs and then the Formatting is done at the end.

It inserts a column, HLINK as the first field and then loops from first row to the last row containing data to insert a hyperlink on the first column. Since the number of rows maybe from 1000 or more,
it takes a while to loop. Is there a way to make this fast?

Please Login or Register  to view this content.

Thanks,
Rollin

**Norie** · 02-01-2018, 02:17 PM

Rollin

Couldn't you use the HYPERLINK function for the hyperlink?

If you could then you wouldn't need to loop.

**rollin** · 02-01-2018, 02:22 PM

Hi,
Thanks. Can you please explain how my code would work with the HYPERLINK function?

an example would help.

**Norie** · 02-01-2018, 02:47 PM

Not sure about your exact URL but it might look something like this.

Please Login or Register  to view this content.

Note, you might not need the font formatting part.

**EssoExplJoe** · 02-02-2018, 01:27 PM

Adding "Application.ScreenUpdating = False" before the loop starts might help. Also setting the worksheet recalculation to False might help.

Loop Through Rows faster

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through Rows faster

Re: Loop Through Rows faster

Re: Loop Through Rows faster

Re: Loop Through Rows faster

Re: Loop Through Rows faster

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] For Each Loop (Make it Faster)

[SOLVED] faster way to loop

Is there a faster way than a loop to delete rows that satisfy a criteria

Is it possible to get rid of this loop to make the code faster?

Make loop run faster

Making a simple loop faster

[SOLVED] Faster For-Next Loop?

Bookmarks

Bookmarks

Posting Permissions