View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default VBA to hide rows?

Hi S Davis

Rows(5 & ":" & 35).Hidden = True



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"S Davis" wrote in message oups.com...
Hello,

If possible, I would like a simple button to hide & show a set number
of rows (rows 5 - 35). Can this be done?

Thanks
-SD