Hi Everybody,

I recently started to learn vba by myself so don't be too arsch if my questoin seems stupid.

In order to perform a more complicated task, I would like to create a button which directs me to another sheet. Here is my actual vba :

Private Sub CommandButton1_Click()

Sheets("06.01 - 10.01.2020").Select

End Sub

I would like to replace "06.01 - 10.01.2020" by the content of a cell in my active sheet, is it possible ? Does it change anything if the cell I want to use is on another sheet ?

Also, is it possible to implement a formula in this code ? (something like
Sheets("=RANK.EQ(A1:A55)").Select for example)

Thanks in advance for any answer that you may have !!