Hi there,
Can you tell when one has to reference a cell by the spreadsheet name it
belongs to and when it is not required?

Calling this sub from Sheet1
Sub Button1
Worksheets("Sheet2").Activate
Range("A3").Select
End
Return Range("A3") from Sheet1

#1: Is the solution to use Worksheets("Sheet2").Range("A3")?
#2: Is the solution to use use named range (unique for the workbook) for
Worksheets("Sheet2").Range("A3") and then reference this name directly

Thanks
Ben