| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hidden Rows
Is there a way to hide a row till information is entered?
Example: If cell c1 0 then rows 7 through 10 will be visible else they will be hidden. -- Thanks |
|
#2
|
|||
|
|||
|
You can use a worksheet_change event macro. Right click sheet tabview code
-- Don Guillett SalesAid Software "Curt" wrote in message ... Is there a way to hide a row till information is entered? Example: If cell c1 0 then rows 7 through 10 will be visible else they will be hidden. -- Thanks |
|
#3
|
|||
|
|||
|
This is the code I am using but it keeps giving me an error:
If c1 0 Then Row([7]).Visible Else Row([7]).Hidden Where is my syntax wrong at??? -- Thanks "Don Guillett" wrote: You can use a worksheet_change event macro. Right click sheet tabview code -- Don Guillett SalesAid Software "Curt" wrote in message ... Is there a way to hide a row till information is entered? Example: If cell c1 0 then rows 7 through 10 will be visible else they will be hidden. -- Thanks |
|
#4
|
|||
|
|||
|
Try
If Range("C1").Value 0 Then Rows(7).Hidden = False Else Rows(7).Hidden = True End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Curt" wrote in message ... This is the code I am using but it keeps giving me an error: If c1 0 Then Row([7]).Visible Else Row([7]).Hidden Where is my syntax wrong at??? -- Thanks "Don Guillett" wrote: You can use a worksheet_change event macro. Right click sheet tabview code -- Don Guillett SalesAid Software "Curt" wrote in message ... Is there a way to hide a row till information is entered? Example: If cell c1 0 then rows 7 through 10 will be visible else they will be hidden. -- Thanks |
|
#5
|
|||
|
|||
|
Thank you Chip, it works great
-- Thanks "Chip Pearson" wrote: Try If Range("C1").Value 0 Then Rows(7).Hidden = False Else Rows(7).Hidden = True End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Curt" wrote in message ... This is the code I am using but it keeps giving me an error: If c1 0 Then Row([7]).Visible Else Row([7]).Hidden Where is my syntax wrong at??? -- Thanks "Don Guillett" wrote: You can use a worksheet_change event macro. Right click sheet tabview code -- Don Guillett SalesAid Software "Curt" wrote in message ... Is there a way to hide a row till information is entered? Example: If cell c1 0 then rows 7 through 10 will be visible else they will be hidden. -- Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) | |||
| Can't See Rows (not hidden) | Excel Discussion (Misc queries) | |||
| Can't See Rows (not hidden) | Excel Discussion (Misc queries) | |||
Linear Mode
