Advanced EXCEL

Using the $ symbol.
Ex: $A $1 – Here Locked Column A and row 1

The function will return a value whereas Subroutine may or may not return a value. The function can be called in the procedure. We can create custom functions using FUNCTION like built-in functions.

No, it will not. VBA is an Object-based programming language, not Object Oriented Programming language.

ThisWorkbook – is the workbook where the VBA code is written.
ActiveWorkbook – is the workbook which is in Active state at present.

Step by step execution – F8
Breakpoints – F9
Using Debug.Print
Immediate Window
Watch Window