![]() Do I understand that the links are not visible but hidden behind the text in a cell? Or just click on the text and it goes to the link address, the link dialog box should show the text in the top section but the link address in the bottom section if I am thinking correctly? What is different about the 10% without links and the 90% of the rows with links. If you can do it one time, I can do it 5000 times automated, I hope. I am not good enough with VB or VBA to give you the answer but I use an external piece of software and it may do what you want and it may work pretty fast also.Ĭan you please post a sample of your excel cells and explain in great detail exactly what you would like to do if it could be done in any way, shaper or form, lets assume that VB or VBA is not going to be used, cause if I think you want to do what I think you want to do, I can probably do it with another piece of software, this of course is assuming that you dont absolutely need to use VBA.Ĭan you do what you want to do by hand for just one row of info, grab the hyperlink, put it in its own column, repair it or update it to a new address and since it is in its own column now, this will make this column of hyperlinks or the entire sheet sortable based on the column of hyperlinks? ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |