Excel Error 1004: button that brings me to the same cell but on another tab

Hello guys!

I have been having an error with a button I made, I have little to no coding knowledge. The button is supposed to bring me to the same cell on another tab called "Screens".

The code:

Sub NaarScreens()
rij = ActiveCell.Activate
Worksheets("Screens").Activate
Cells(rij, 1).Select
End Sub

It marks the last row Cells(rij, 1).Select yellow and it seems the issue is with this piece of code.

Hi & welcome to the board.
Another option

Please Login or Register  to view this content.

First and foremost thanks for awnsering! unfortunately, I keep having the same error even with this code, I read on some forums that this could be the doing of my machine specifically but I don't really know.

Thanks for the welcome! and i appreciate the help, this solution worked for me!

Glad to help & thanks for the feedback

With protonLeah's code you need to make this change & it should work

Please Login or Register  to view this content.