"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