MM0010 - 03/02/20 - Two Examples of Application.WorksheetFunction

This powerful VBA technique allows you to access worksheet formulae from the VBA editor.  Let's understand its unique power by working through an example related to our current project.

Topics

  •  | Dawid - Homework Review
  •  | Bart - Homework Review
  •  | Discussion Of Module Names
  •  | .end(xldown)
  •  | Sources Of Code
  •  | Nigel - Homework Review
  •  | Importance Of Metacognition
  •  | MATCH
  •  | Subscript Out Of Range Error
  •  | Application.WorksheetFunction.Match
  •  | Application.WorksheetFunction Explanation
  •  | Application.WorksheetFunction Advantages
  •  | COUNTIF
  •  | Application.WorksheetFunction.Countif
  •  | Unable To Get The Match Property Error
1 Lesson