Differrence bewteen Rows(X) and Rows(X).EntireRow
 

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?

Differrence bewteen Rows(X) and Rows(X).EntireRow
 

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" wrote in message
...
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?

Differrence bewteen Rows(X) and Rows(X).EntireRow
 

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

"Zoo" wrote in message
...
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?

Differrence bewteen Rows(X) and Rows(X).EntireRow
 

Thank you , Chip , Don.

I will use EntireRow.

"Don Guillett" wrote in message
...
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

"Zoo" wrote in message
...
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?