Habe mal wieder eine Bitte um Hilfe von Euch.
Ich habe folgendes Makro.
Sub AAAAAUrlaub_Hyperlinks_auf()
' AAAAAUrlaub_Hyperlinks_auf '
Range("S2").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S222", ScreenTip:="Sep 2022", TextToDisplay:= _
"Sep 2022"
Range("S223").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S443", ScreenTip:="Nov 2022", TextToDisplay:= _
"Nov 2022"
Range("S444").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S664", ScreenTip:="Jan 2023", TextToDisplay:= _
"Jan 2023"
Range("S665").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S885", ScreenTip:="Mrz 2023", TextToDisplay:= _
"Mrz 2023"
Range("S886").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S1106", ScreenTip:="Mai 2023", TextToDisplay:= _
"Mai 2023"
Range("S1107").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S1327", ScreenTip:="Juli 2023", TextToDisplay:= _
"Juli 2023"
Range("S1328").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S1548", ScreenTip:="Sep 2023", TextToDisplay:= _
"Sep 2023"
Range("S1549").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S1783", ScreenTip:="Nov 2023", TextToDisplay:= _
"Nov 2023"
Range("S1784").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S1990", ScreenTip:="Dez 2023", TextToDisplay:= _
"Dez 2023"
Range("S1991").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S2027", ScreenTip:="Jan 2024", TextToDisplay:= _
"Jan 2024"
Range("S2028").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S2432", ScreenTip:="Apr 2024", TextToDisplay:= _
"Apr 2024"
Range("S2433").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S2653", ScreenTip:="Jun 2024", TextToDisplay:= _
"Jun 2024"
Range("S2654").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S2874", ScreenTip:="Aug 2024", TextToDisplay:= _
"Aug 2024"
Range("S2875").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S3095", ScreenTip:="Okt 2024", TextToDisplay:= _
"Okt 2024"
Range("S3096").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S3316", ScreenTip:="Nov 2024", TextToDisplay:= _
"Nov 2024"
Range("S3317").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S3537", ScreenTip:="Jan 2025", TextToDisplay:= _
"Jan 2025"
Range("S3538").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S3760", ScreenTip:="Mrz 2025", TextToDisplay:= _
"Mrz 2025"
Range("S3761").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S3981", ScreenTip:="Mai 2025", TextToDisplay:= _
"Mai 2025"
Range("S3982").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S4202", ScreenTip:="Jul 2025", TextToDisplay:= _
"Jul 2025"
Range("S4203").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S4423", ScreenTip:="Sep 2025", TextToDisplay:= _
"Sep 2025"
Range("S4424").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S4644", ScreenTip:="Nov 2025", TextToDisplay:= _
"Nov 2025"
Range("S4645").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S4865", ScreenTip:="Jan 2026", TextToDisplay:= _
"Jan 2026"
Range("S4866").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Url.Krak.Austrg.!S5086", ScreenTip:="Mrz 2026", TextToDisplay:= _
"Mrz 2026"
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Range("S5").Select
End Sub
Die Hyperlinks funktionieren aufsteigend in der Jeweiligen Spalte (S).Nun meine Frage? Ist es möglich, das ich in N das gleiche Absteigend in Spalte (N) in gleichen Schritten tuen kann per Makro.
Wäre schön wenn sich das mal jemand anschauen könnte. Wie müsste ich es schreiebn?
Ich danke Euch im voraus
LG Robert