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