Getting a compile error with a very simple VBA code

[borski88]

I have this simple code open a hidden sheet:

Sub Test()
    
    Sheets("sheet1").Visible = True
    Sheets("sheet1").Select

End Sub

I get the following Compile Error:

Compile Error:
Wrong number of arguments or invalid property assignments

 

[Michael M]

Where are you putting the code.....there is no reason that it shouldn't work !
IS the sheet hidden or VeryHidden ?

 

[borski88]

Try..

Sheets("sheet1").Visible = xlSheetVisible

Hope this helps!

I get the same error with this. I'm not sure whats up, Ive used more advanced VBA than this before without issues lol

 

[borski88]

Where are you putting the code.....there is no reason that it shouldn't work !
IS the sheet hidden or VeryHidden ?

module1

Just hidden, not very hidden

 

[Domenic]

Yeah, Michael is right. There's no reason why it shouldn't work, whether hidden or very hidden. When the error occurs, which text gets highlighted?

 

[borski88]

Yeah, Michael is right. There's no reason why it shouldn't work, whether hidden or very hidden. When the error occurs, which text gets highlighted?

Sub Test()

is what gets highlighted

 

[JackDanIce]

It's not clear what is being highlighted in your example.

This works fine for me and as others above, seem unable to replicate your error:

Sub Test()


    With Sheets("Sheet1")
        .Visible = True
        .Select
    End With


End Sub

Maybe a typo in the sheet name you're using? Have you tried running the same code in a different (new) workbook?

 

[svendiamond]

Try this:

Sub Test()
    
With Application.Sheets("Sheet1")
    .Visible = True
    .Select
End With


End Sub

 

[svendiamond]

Actually I have a question... are you simply trying to run this code by itself, or are you calling it from somewhere else? If you step through your code does it work?

 

[borski88]

Try this:

Sub Test()
    
With Application.Sheets("Sheet1")
    .Visible = True
    .Select
End With


End Sub

That worked!