Opening Different Sheets

  • Thread starter Thread starter N1KO
  • Start date Start date
N

N1KO

I've managed to get a cell value to change and i now need to get a command
button to open a sheet which is named exactly the same as that cell value.

So I have Cell J1's value to be 01BudgetJan. I need the command button to
open the sheet called 01BudgetJan. Is this possible?

This value can change so need the button to open whatever sheet has the name
of the cells value.

Thanks in advance.
 
Insert this line in commandbutton code:
Worksheets(Range("J1")).Activate

Regards,
Stefi

„N1KO†ezt írta:
 
Back
Top