MM0014 - 02/03/20 - Automate Creation of Hyperlinks with Excel VBA 2

Learn how to integrate hundreds of hyperlinks into an Excel VBA application at the click of a button. Let's use loops and position control to scale up last week's code to create a powerful and flexible solution to this real-world problem.

Topics

  •  | Jazfin - Homework Review
  •  | Bart - Homework Review
  •  | Overflow Error
  •  | Named Range Example
  •  | Long Variable Example
  •  | Discussion: Integer Vs. Long Variables
  •  | .Cells
  •  | .End(xlup)
  •  | Assumptions Example
  •  | .Count
  •  | For Each Loop
  •  | LEFT
  •  | Range(Range,Range) Example
  •  | .Address
  •  | If Statement - IF - END IF
1 Lesson