View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lee lee is offline
external usenet poster
 
Posts: 184
Default hiding rows with a macro

I haven't done any kind of programming in about 5 years. What I want to do
is, have a IF function in cell "A1" that checks if "C1" has anything < than
0. If it is < 0 leave row1 visable, if it =0 then hide row1. I need to do
this for about 20 rows, if later data is entered in "C1" thru "C20"it would
automatically Hide or unhide the rows.

is this possible?