• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HOW TO HIDE THE UNWANTED ROW

A B C D E

1 TRUE 1 SIVA 10 15

2 TRUE 2 SIVA 20 16

3 TRUE 3 SIVA 5 18

4 TRUE 4 SIVA 12 25

5 TRUE 5 SIVA 18 30

6 FALSE

7 FALSE

8 FALSE

9 FALSE

10 FALSE

sir, suppose I have 10 rows , but I have data in only first five row how hide the remaining five rows (A Column which has False condition ) automatically . Please Anyone reply
 
@shivakumar


Hi


Welcome to Chandoo.org Forum, glad your are here


please try the below code for when the worksheet is activate the blank rows are going to hide

[pre]
Code: 
Private Sub Worksheet_Activate()
Dim c As Range
For Each c In Range("A2:A1000")
If c.Value = "" Then
c.EntireRow.Hidden = True
Else
c.EntireRow.Hidden = False
End If
Next c
End Sub

for unhide the Hidden Rows use the below code


Sub UnhideRows()
Dim c As Range
For Each c In Range("A2:A1000")
c.EntireRow.Hidden = False
Next c
End Sub
[/pre]
if any problem please refer us again


Thanks


SP
 
sir

as your guidelines I try my best

but not working

if you send me your mail address I will send the file which I used

help me sir

thank you

my mail address

sivakumar6776.sr@gmail.com
 
@sivakumar


HI


Please share your file from the below link


http://chandoo.org/forums/topic/posting-a-sample-workbook


it is better to use the drop box link


Thanks


SP
 
@sgmpatnaik

hi

as per guidelines given by you

and I made a small correction on trial error method I reach my goal

thank you sir

https://www.dropbox.com/s/35r37x2dxy1c2f9/test%20question%202%20HIDE%20ALL%20ROWS%201.xlsm
 
if it were me, and im not sure if this work or not for your worksheet, but a possibly easier way would be to simply enable filtering for each of your fields and in your first field (colA) just select the "TRUE" option... that way any Rows with False would not be displayed.


....again, it may or may not work as the layout/setup of the rest of your worksheet may contain other factors; but just an idea.
 
To sgmpatnaik

Thank you sir


To: jason

Yes your correct But I used it in different file. This will be used many users without knowing excel options. so that only I asked

For your reference please click the below link

https://www.dropbox.com/s/d0svzag85tduwbj/PROMOTION%20CHART%201%20TO%208TH%20STD%20CORRECT%20As%20ON%2022%2003%202013.xlsm

Thank you sir
 
You must log in or register to reply here.
Back
Top