MM0009 - 27/01/20 - Find The 'Last Row' In A Dataset Using Excel VBA

VBA is great - but routines that do not cater for additional (or fewer) rows of data are not useful for long.  Let's look at how to build in a crucial piece of dynamic quality by finding the 'last row', regardless of the size of the dataset.

Topics

  •  | Bart - Homework Review
  •  | Overflow Error
  •  | Named Range Example
  •  | IF Statement - IF - ELSE - END IF
  •  | .Offset
  •  | Discusion Of Advantages Of Named Ranges
  •  | .Row
  •  | Type Mismatch Error
  •  | .end(xldown)
  •  | Subscript Out Of Range Error
  •  | Enjoy The Power!
  •  | Learning Is Not Linear
1 Lesson