I want makro which can find out which cells are empty in area a12:a35 and
hide those rows where cells are empty.

"Alen32" wrote:

I want makro which can find out which cells are empty in area a12:a35 and
hide those rows where cells are empty.



One way:-

Sub HideRows()
For a = 12 To 35
If Cells(a, 1) = "" Then
Cells(a, 1).Select
Selection.EntireRow.Hidden = True
End If
Next a
End Sub

doesn't work.

"Alen32" wrote:

doesn't work.


Should do. I trust you copied the lines into a new module
( Alt+F11InsertModule )

it works in some sheets but dosn't work in some others sheets. I don't know
why

Depends on whether the cells are empty or contain a space, I guess

thanks!