Overflow error, long processing time

I have a column with image names. For example; image.jpg.

I want the code to convert the image name to a clickable hyperlink. When i1 is set as integer, I will get an Overflow error. Changed it to Long and now it works. However, it takes about 2 minutes for the code to complete the operation and the sheet is inaccessible.

I only have a few images in my sheet so I do not understand why it would take a couple of minutes to convert to a hyperlink. Any ideas?

Please Login or Register  to view this content.

Hi,

you forgot to swith off the display before the loop to speed up the procedure !
See VBA help of ScreenUpdating property …

A good code doesn't use Goto …

But it's not necessary to create hyperlink to open / view a file !
Easier way is to control a double click event for example …
Attach an example workbook without any hyperlink, just the column of file name,
and I could post a code example …

I will also suggest you use .Value property rather than .Text which may be slow if you have a lot of rows.

Just by a double click on the file name without any hyperlink on the cell,
if the cell is in column B and the file exists in the same workbook's path,
code to insert directly in the Sheet1 worksheet module class (not a standard one) :

Please Login or Register  to view this content.

Another Way :

Please Login or Register  to view this content.

Last but not least …

Please Login or Register  to view this content.

Enjoy !