Hi to all Tip Master's,
How to Automate programmatically Hyperlink from sheet1 to sheet2
i have existing programs :
With oExcel
.sheets("Sheet2").Select
.sheets.Add.Name = Variable1
.Sheets("Sheet1").select
Endwith
After this Procedure i need to hyperlink
let say
.Sheets("Sheet1").select
.Range("A5").select
to ..... Sheet2 or Variable1
Thanksalot,
How to Automate programmatically Hyperlink from sheet1 to sheet2
i have existing programs :
With oExcel
.sheets("Sheet2").Select
.sheets.Add.Name = Variable1
.Sheets("Sheet1").select
Endwith
After this Procedure i need to hyperlink
let say
.Sheets("Sheet1").select
.Range("A5").select
to ..... Sheet2 or Variable1
Thanksalot,