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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zoo - 22 Jan 2007 12:57 GMT

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?

Reply to this Message

Chip Pearson - 22 Jan 2007 13:22 GMT

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.

Signature

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

> Hi,
> I want to unhide row x.
[quoted text clipped - 3 lines]
> B: Rows(x).EntireRow.Hidden = False
> Is there any situation that A doet not work properly?

Reply to this Message

Don Guillett - 22 Jan 2007 13:48 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
> I want to unhide row x.
[quoted text clipped - 3 lines]
> B: Rows(x).EntireRow.Hidden = False
> Is there any situation that A doet not work properly?

Reply to this Message

Zoo - 23 Jan 2007 01:13 GMT

Thank you , Chip , Don.

I will use EntireRow.

> None
> Typically you would use the second to UN limit the range
[quoted text clipped - 10 lines]
>> B: Rows(x).EntireRow.Hidden = False
>> Is there any situation that A doet not work properly?

Reply to this Message