Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows Without Using VBA
Hi everyone,
Can you do something like: In a cell such as F1, can you type thing like: If B1=1, then hide row 1? If there is no way but using VBA, what such a code should look like? Regards, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows Without Using VBA
Assuming you are in row 1, the VBA could be
If Range("B1") = 1 Then ActiveCell.EntireRow.Hidden = True End If Ed "Michael" wrote in message om... Hi everyone, Can you do something like: In a cell such as F1, can you type thing like: If B1=1, then hide row 1? If there is no way but using VBA, what such a code should look like? Regards, Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows Without Using VBA
Try this
If ActiveSheet.Range("B1").Value = 1 Then ActiveSheet.Rows("1").Hidden = False Else End If Best of luck DavidC -----Original Message----- Hi everyone, Can you do something like: In a cell such as F1, can you type thing like: If B1=1, then hide row 1? If there is no way but using VBA, what such a code should look like? Regards, Mike . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows Without Using VBA
"DavidC" wrote in message ...
Try this If ActiveSheet.Range("B1").Value = 1 Then ActiveSheet.Rows("1").Hidden = False Else End If Best of luck DavidC -----Original Message----- Hi everyone, Can you do something like: In a cell such as F1, can you type thing like: If B1=1, then hide row 1? If there is no way but using VBA, what such a code should look like? Regards, Mike . I am using this but not working: Set rngBlock = Workbooks(filename).Worksheets("ParetoTable").Rang e("B10:B59") For Each rngCell In rngBlock If rngCell.Value < 1 Then ActiveCell.EntireRow.Hidden = True End If Next rngCell It gives no error but not hiding anything? Anything wrong please? Regards, Mike |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows Without Using VBA
You can only hide entire rows or columns. That is why your script doe
not work -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows Without Using VBA
Okay, but if the range is NOT known in advance and you have to go row by row, check, and decide row-by-row, how the above VBA piece of code can be modified to do so? Regards, Mike *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color alternate rows when after hiding selected rows | Excel Worksheet Functions | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |