LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
Zoo Zoo is offline
external usenet poster
 
Posts: 40
Default 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?




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto extract data & inserts rows additional rows automatically Meeru Excel Discussion (Misc queries) 3 September 9th 09 01:46 PM
Enabling option „Format rows“ to hide/unhide rows using VBA-code? ran58 Excel Discussion (Misc queries) 0 July 28th 09 03:46 PM
Counting characters in multiple rows when rows meet specific criteria news.virginmedia.com Excel Worksheet Functions 3 June 28th 08 09:03 PM
Copy rows of data (eliminating blank rows) from fixed layout Sweepea Excel Discussion (Misc queries) 1 March 13th 07 11:05 PM
EntireRow.Delete only removing half of the rows KelliInCali Excel Programming 11 February 27th 06 09:36 PM


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"