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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com