I couldn't get anything to work.. that is why I made this suggestion...
The only thing that worked, was resulting in an Error, but if I double-clicked it opened the A1 hyperlink...
.. maybe someone can code it with VBA..
Note: That the Morefunc.xlll addin is embeddable in the workbook, so that you can share it without having others download the addin too.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks, it works but I bumped into a new problem.
The described case is for single cell, but I have a huge table to do that.
How can I multiply that cell with auto-increment cell position.
I mean if this written for A1 in spreadsheet A, and the hyperlink defined in cell A1 of spreadsheet B i want to define the rule by mouse dragging or any other automatic way for cells spreadsheet A cell A2 etc...
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks