Range.Hyperlinks.Count failing

my code not working and i think it is right. can someone check? i am looping 25 rows backwards stepping and 4 out of 25 cells are being missed or the code executing on those cells when it should not be. here is code

Please Login or Register  to view this content.

i also attached images for what i have to this post. i cant see my mistake. i dont think there is one. is there? my pics show code broken on row 16 and the first mistake it makes.

Without knowing what it is you're trying to accomplish, it's difficult to determine the problem.


Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

i do not know what desensitizing means. sorry. here is workbook. i describe issue perfectly though. is not tough.
i am looping a range and inserting cells. that is all. simple. this is not for a business.

there is one code routine in workbook i uploaded. i have 4 sheets for you. before code. after code. what i'd like to see. and all the data i
have available for use and to run code on. as you see, code is making mistakes. funny thing is. if i run same code on different samples from data
in the "all data" tab, it works fine! i think something is wrong with actual data. it is like excel thinks some are not links, but they all really are.
code is doing nothing but apply conditional IF on cells based on hyperlink tests.

what is wrong?

question:

so if 'currentregion' works, and your code is supposed to point to or select what i am currently looping

Please Login or Register  to view this content.

then why does article by microsoft not say that?

https://docs.microsoft.com/en-us/off....currentregion

and why do you think that those URL links are not being put into those cells? the addresses are getting into cells by me copy and paste from the firefox browser address bar when i look up the pages on youtube. is that doing it? because if some are there and some not, i am doing same thing for all. so that not make sense.

Originally Posted by omahaNative_1023

and why do you think that those URL links are not being put into those cells? the addresses are getting into cells by me copy and paste from the firefox browser address bar when i look up the pages on youtube. is that doing it? because if some are there and some not, i am doing same thing for all. so that not make sense.

Sorry, I haven't a clue... might try asking in a new thread.

thank you ,.......

Glad to help when I can!