set row height to zero if the condition satisfy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear friends,
Please let me know, how to set the row height into zero if the condition
satisfy
 
A macro maybe:-
Sub sonic()
LastrowColA = Range("A65536").End(xlUp).Row
For x = LastrowColA To 1 Step -1
Cells(x, 1).Select
If ActiveCell.Value = "mycriteria" Then
ActiveCell.EntireRow.Hidden = True
End If
Next x
End Sub

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting row height not to exceed... 1
Conditional Row Height 3
Satisfying two conditions? 8
Row Height property 1
Excel row height 2
How set many row heighths = height of another row 1
how to get value from a table satisfying two conditions 2
Row height setting problem 8

Back
Top