excel vba code checks series of 4 named ranges for unhidden range then unhides 1,can repeat 4x

[jtatt]

hello
I have four named ranges tcd1, tcd2, tcd3 and tcd4 which are all hidden when user opens sheet
What I would appreciate is vba code (if it's possible) when the user clicks macro button
code checks tcd1,2,3 and 4 for their hidden/unhidden status and unhides one of the hidden named ranges

then if the user runs the code a 2nd time code checks tcd1,2,3 and 4 for hidden range and unhides one of the hidden ranges

user can then repeat running the macro a 3rd and 4th time to unhide one more range each time

if the user clicks the macro button a 5th time a message box or error shows that there are no further reports

tcd1,2,3 and 4 appear the same, order they are unhidden is not important

My apologies that I have not experimented with code
Thank you for reading my request for help
Julie

 

[footoo]

What version of XL do you have?
In more recent versions, tcd1/tcd2/tcd3/tcd4 cannot be used as names because they are cell references.
I suggest you change to some other names (for example, like in the macro below.

How are the ranges hidden? By rows or by columns?
Assuming by rows :

Sub v()
Dim r%, x%
For r = 1 To 4
    If Range("tcd_" & r).EntireRow.Hidden = True Then
        Range("tcd_" & r).EntireRow.Hidden = False
        x = 1
        Exit For
    End If
Next
If x <> 1 Then MsgBox "No further reports"
End Sub