I have a problem in my vba when referencing some specific sheets number/codename. See below this working:

Sheet37.Range("A3:A35").EntireRow.Hidden = False

But this is not working:

Sheet10.Range("A6:A14").EntireRow.Hidden = False

For some reason, Excel can’t reference this sheet and a few others, while I have no problem with most of the sheets in the workbook. Morever, I have retrieved a previous version from my file where the exact same code works totally fine.

I really do not see a reason as to why this would happen so any help is more than welcomed.

Many thanks in advance