In I1, put formula =HYPERLINK(J:J)
click on J1, I1=a and click on J2, I1=a
but I want: click on J2, I1=b
plse re-write formula
In I1, put formula =HYPERLINK(J:J)
click on J1, I1=a and click on J2, I1=a
but I want: click on J2, I1=b
plse re-write formula
Maybe need this
=HYPERLINK(J1) then copy down
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Hi
Try the code below. I have also uploaded the file with this code. check it out:
Data.xlsm![]()
Please Login or Register to view this content.
Regards..
Click *, if my suggestion helps you. Have a good day!!
sloved
Thank you
a=^dji and b=^sti
Is not working when running the following macro
![]()
Please Login or Register to view this content.
Last edited by asdzxc; 05-15-2012 at 08:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks