Consider the following VBA command:

Range$("$A$1").$Select

What will this do

$1.$

Select cell A$1$ on the active worksheet in the workbook which contains the macro

$2.$

Select cell A$1$ on the first worksheet in the workbook which contains the macro

$3.$

Give an error $($the cell reference needs to be in capitals$)$

$4.$

Select cell A$1$ on the active worksheet in the active workbook