Advanced EXCEL

Avatto > > DATA SCIENTIST > > SHORT QUESTIONS > > 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