View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default Hiding rows based on cell content

try this simple code:

Option Explicit
Sub test()
delete_row Selection
End Sub


Sub delete_row(target As Range)

If target.Value = "False" Then
Rows(target.Row).Delete
End If

End Sub


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I am looking to hide a row in a worksheet where the

column o contains
the value false.This sounds easy but just cant get my

head round it.


---
Message posted from http://www.ExcelForum.com/

.