How does this work?

[VegasNath]

Code: Select all

Sub Show_All()

    Rows.Hidden = Fales
    
End Sub

:conused:

[HansV]

Does it literally have "Fales" or is that a typo?

[VegasNath]

No, it works with fales. It also works with fale.

[StuartR]

Most odd, even though I have
Option Explicit
at the beginning of this module, it still accepts this as valid...

[HansV]

I still think it has to do with the lack of Option Explicit. If the variable Fales is not declared, its default value is Null, which in many situations is treated the same as 0, "" and False.

I do get an error message:

x459.jpg

[Don Wells]

I am running 2003 SP 3 and Nathan's code makes all hidden rows visible on the active sheet on my machine. Go figure.

[HansV]

Do you have Option Explicit at the top of the module?

[Don Wells]

Do you have Option Explicit at the top of the module?

With "Option Explicit" the code will not run.
Without "Option Explicit" the code interprets "Fales" as "False".

[HansV]

That's to be expected, as I explained higher up in this thread.

I'd like to point readers of this thread to The importance of 'Option Explicit'. It really is important to require variables to be declared explicitly!

[VegasNath]

That's to be expected, as I explained higher up in this thread.

I'd like to point readers of this thread to The importance of 'Option Explicit'. It really is important to require variables to be declared explicitly!

Ahem, yes, point taken!

all.