Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto extract data & inserts rows additional rows automatically | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
EntireRow.Delete only removing half of the rows | Excel Programming |