Re: $$Excel-Macros$$ HyperLinks to Sheets * * * *

YOU HAVE TO AMEND THE WORKSHEET NAME IN THE CODE TO SUIT UR WORKSHEET NAME On Wed, Jan 16, 2013 at 4:07 PM, Pankaj Singh wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (pankajpepsic...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ HyperLinks to Sheets * * *

Sub ReturnToD3() Worksheets("TEMPLATE (3)").Activate Range("A1").Select End Sub On Wed, Jan 16, 2013 at 3:33 PM, Pankaj Singh wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (pankajpepsic...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ HyperLinks to Sheets * *

How to get back in hyper liked sheet after clicking on hyper link..need code..plz. On Wed, Jan 16, 2013 at 9:00 PM, Hilary Lomotey wrote: > > > > > *BINGO- IT WORKING TO PERFECTION,* > * > * > *very grateful Ashish and Rajan > * > * > * > * > * > * > * > On Wed, Jan 16, 2013 at 3:18 PM, ashish k

Re: $$Excel-Macros$$ HyperLinks to Sheets * *

*BINGO- IT WORKING TO PERFECTION,* * * *very grateful Ashish and Rajan * * * * * * * On Wed, Jan 16, 2013 at 3:18 PM, ashish koul wrote: > Sub CreateLinksToAllSheets() > Dim sh As Worksheet > Dim cell As Range, i As Long, j As Long > i = 1 > j = 1 > > For Each sh In ActiveWorkbook.Worksheets >

Re: $$Excel-Macros$$ HyperLinks to Sheets *

Try this Sub CreateLinksToAllSheets() Dim sh As Worksheet Dim cell As Range, i As Long, j As Long i = 1 j = 1 For Each sh In ActiveWorkbook.Worksheets If ActiveSheet.Name <> sh.Name Then Cells(j, i).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=

Re: $$Excel-Macros$$ HyperLinks to Sheets *

Thanks rajan Being a while, hope you are well .The idea is right but it doesnt actually help my course let me try and explain again if its gets to row 30 in the first column on the second column it should start from row 1 to 30 again in that order. Hope this explains well On Wed, Jan 16, 2013 at

Re: $$Excel-Macros$$ HyperLinks to Sheets

Sub CreateLinksToAllSheets() Dim sh As Worksheet Dim cell As Range For Each sh In ActiveWorkbook.Worksheets If ActiveSheet.Name <> sh.Name Then ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "'" & sh.Name & "'" & "!A1", TextToDisplay:=sh.Name i

$$Excel-Macros$$ HyperLinks to Sheets

Hello Experts, The code below creates hyperlinks in a worksheets, what i require is a little modification to this. assuming i have about 100 sheets in a work book, this code will line up all the hyperlinks of the worksheet name in a single row (ie 100 rows), what i need is that at the end of every