How do ActiveSheet, ActiveWorkbook.ActiveSheet and Application.ActiveSheet behave differently?

Viewed 23607

I am in the habit of of always using ActiveSheet like this: ActiveWorkbook.ActiveSheet. I recently stumbled across this Microsoft page with code that includes ActiveSheet without ActiveWorkbook. The title of that page is Application.ActiveSheet Property.

Is there a difference between these three lines of code?

ActiveSheet
ActiveWorkbook.ActiveSheet
Application.ActiveSheet
1 Answers
Related