Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hyperlink in a vba
Tried it my code as: Sub MakeSummary() ' ' MakeSummary Macro Sheets("SUMMARY").Select ' Clear the existing values (if any) Range("$bb$2:$be$60").Value = "" ' J tracks the row number on the summary page ' I tracks the sheet number being processed j = 2 For I = 3 To...- gregols
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Hyperlink in a vba
This works but only on the last sheet on the list does the hyperlink work. Any ideas why it's only picks this one?- gregols
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Hyperlink in a vba
Hi I'm running a workbook with numerous worksheets. The first worksheet is a summary page where I use the following macro to collect certain info from each worksheet: Sub MakeSummary() ' ' MakeSummary Macro ' Sheets("SUMMARY").Select ' Clear the existing values (if any)...- gregols
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
