View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DavidC[_2_] DavidC[_2_] is offline
external usenet poster
 
Posts: 44
Default Hiding Rows Without Using VBA

Try this

If ActiveSheet.Range("B1").Value = 1 Then

ActiveSheet.Rows("1").Hidden = False

Else

End If

Best of luck
DavidC
-----Original Message-----
Hi everyone,

Can you do something like:

In a cell such as F1, can you type thing like: If B1=1,

then hide row 1?

If there is no way but using VBA, what such a code should

look like?

Regards,
Mike
.