help with code to automatically hid rows if a cell is empty

[bleeet]

hello

i am not good with VBA but i want to make a code in one of of the pages in my excel file so that if nothing appears in a cell in the range of C4 to C23 then the row is automatically hidden and and if something appears the row unhides

dunno if this matters but those cells will show info that come from info on another sheet.

i saw this code on another thread here but i don't know how to adjust this to fit my setting


Private Sub Worksheet_Calculate()
Dim i As Long
For i = 9 To 53
Rows(i).Hidden = Range("A" & i).Value = ""
Next i
End Sub

if anyone knwo how to do this or advice on a better idea please help

i hope you guys understand what i am saying

 

[VoG]

Try

Private Sub Worksheet_Calculate()
Dim i As Long
For i = 4 To 23
    Rows(i).Hidden = Range("C" & i).Value = ""
Next i
End Sub

 

[bleeet]

Try

Private Sub Worksheet_Calculate()
Dim i As Long
For i = 4 To 23
    Rows(i).Hidden = Range("C" & i).Value = ""
Next i
End Sub

thanks VOG

but it's not working i get a run time error and it effect my other sheets i think

 

[VoG]

Are there error values in the range?

 

[bleeet]

Are there error values in the range?

it says run-time '-2147417848 (80010108)

method 'hidden' of object 'range' failed

 

[VoG]

It works for me. Is the sheet protected or filtered?

 

[bleeet]

i am guessing there is an error here

Rows(i).Hidden = Range("C" & i).Value = ""

since it is highlighted in yello when i press debug

 

[VoG]

Are there error values on the sheet like #N/A

 

[bleeet]

It works for me. Is the sheet protected or filtered?

right now the sheet is unprotected

i put the code by right clicking the sheet name and view code it that the right way?

not sure if fitered how do i find that out?

 

[VoG]

Yes, you put the code in the right place.

If the sheet is filtered you will have drop down arrows in row 1.

The code will fail if there are error values like #N/A. Are there errors?