blis
02-21-2010, 09:55 AM
Hello again.
I have macro which copies all hyperlinks in a workbook to newly inserted worksheet "SeznamHyperlink". It works without a problem.
Now i am trying to replace each hyperlink with function. And here is my problem. When i add code that clear contect of active cell, macro is not able to find all the hyperlinks in a worksheet. It finds first hyperlink, but then it doesn't jump to next one but to the 4th one. Also suddenly macro is not able to go to the next worksheet in a workbook. It just finds a few hypelinks in the first worksheet (and also clear the content of cellls and inserts hyperlink function)
Can anyone figure why is this happening. where is a mistake in my code, that is responsible for this jumps and problem when changing worksheet??
Here is the link to workbook http://dc180.4shared.com/download/22...lmost_beta.xls (http://dc180.4shared.com/download/226749179/79342777/Katalog_almost_beta.xls)
The macro has some blocked rows of code at the end. If you run macro with this rows blocked, macro works. It lists all hyperlink found on new sheet. When the macro is ran with this blocked rows, then it doesn't find all the hyperlinks and can't change active sheet.
Pls someone help me with this one.
I have macro which copies all hyperlinks in a workbook to newly inserted worksheet "SeznamHyperlink". It works without a problem.
Now i am trying to replace each hyperlink with function. And here is my problem. When i add code that clear contect of active cell, macro is not able to find all the hyperlinks in a worksheet. It finds first hyperlink, but then it doesn't jump to next one but to the 4th one. Also suddenly macro is not able to go to the next worksheet in a workbook. It just finds a few hypelinks in the first worksheet (and also clear the content of cellls and inserts hyperlink function)
Can anyone figure why is this happening. where is a mistake in my code, that is responsible for this jumps and problem when changing worksheet??
Here is the link to workbook http://dc180.4shared.com/download/22...lmost_beta.xls (http://dc180.4shared.com/download/226749179/79342777/Katalog_almost_beta.xls)
The macro has some blocked rows of code at the end. If you run macro with this rows blocked, macro works. It lists all hyperlink found on new sheet. When the macro is ran with this blocked rows, then it doesn't find all the hyperlinks and can't change active sheet.
Pls someone help me with this one.