Hi,
I want to unhide row x.
Is there any difference between result of A and that of B?

A: Rows(x).Hidden = False
B: Rows(x).EntireRow.Hidden = False

Is there any situation that A doet not work properly?

The two lines of code perform identically. The second probably takes a
nanosecond or two longer to execute. Which syntax to use is a stylistic
decision. I typically use the syntax of the second line, simply to provide
further documentation that the entire row is being deleted. It's habit and
harmless.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Zoo" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I want to unhide row x.
> Is there any difference between result of A and that of B?
>
> A: Rows(x).Hidden = False
> B: Rows(x).EntireRow.Hidden = False
> Is there any situation that A doet not work properly?
>

None
Typically you would use the second to UN limit the range
with range("x2")
.value=3 'only that cell
.entirerow.dosomething
end with


--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Zoo" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I want to unhide row x.
> Is there any difference between result of A and that of B?
>
> A: Rows(x).Hidden = False
> B: Rows(x).EntireRow.Hidden = False
> Is there any situation that A doet not work properly?
>

Thank you , Chip , Don.

I will use EntireRow.

"Don Guillett" <(E-Mail Removed)> wrote in message
news:u$(E-Mail Removed)...
> None
> Typically you would use the second to UN limit the range
> with range("x2")
> .value=3 'only that cell
> .entirerow.dosomething
> end with
>
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Zoo" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi,
>> I want to unhide row x.
>> Is there any difference between result of A and that of B?
>>
>> A: Rows(x).Hidden = False
>> B: Rows(x).EntireRow.Hidden = False
>> Is there any situation that A doet not work properly?
>>
>
>