HOW TO HIDE THE UNWANTED ROW

[sivakumar rathinam]

sir, suppose I have 10 rows , but I have data in only first five row how hide the remaining five rows automatically anyone reply

 

[sivakumar rathinam]

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

 

[sgmpatnaik]

@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]

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

 

[sivakumar rathinam]

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

 

[sgmpatnaik]

@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

 

[sivakumar rathinam]

@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

 

[sgmpatnaik]

Glad you solve your problem


if any issue please refer us


Thanks


SP

 

[jason]

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.

 

[sivakumar rathinam]

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