Dynamic Hyperlink

Hi All,

I just want to make Subaddress for the below hyperlink code to be dynamic ie call input value from variant.

Please Login or Register  to view this content.

.

Instead of FWC,i want to call it from the below variant. ie replace FWC with SheetName

Please Login or Register  to view this content.

Instead of A1, i want to call it from the below variant. ie replace A1 with CelAddres

Please Login or Register  to view this content.

Both the Variant SheetName and CelAddres are stored in while the macro is running in another sheet in same workbook.

Thanks in advance for your help.

Regards,

Nazim

Originally Posted by nazimscr

Both the Variant SheetName and CelAddres are stored in while the macro is running in another sheet in same workbook.

Not entirely sure I follow the above but in general terms based on your prior code:

Please Login or Register  to view this content.