How do I add exactly which worksheet to run the macro on

[K0st4din]

Hello, everyone,
please help me how to add in which worksheet to do (execute) this macro.
Thank you in advance for your assistance!

Dim Last_Row As Long
Last_Row = Range("A:A").SpecialCells(xlCellTypeLastCell).Row ->>>> how to add to be in sheet with name Banan

MsgBox "You have to print total page: " & Lastrow
'MsgBox Last_Row
    Application.ScreenUpdating = False

 

[mumps]

How about:

Dim Last_Row As Long
Last_Row = Sheets("Banan").Range("A:A").SpecialCells(xlCellTypeLastCell).Row
MsgBox "You have to print total page: " & Lastrow
'MsgBox Last_Row
    Application.ScreenUpdating = False

 

[K0st4din]

Thank you very much for your prompt assistance.
Be alive and healthy!

 

[mumps]

You are very welcome.