Do one of two things:
Use from the Main Menu Bar
Data - Filter and select autofilter
Then click on the dropdown box and select your criteria.
Or
Rows("1:35").EntireRow.Hidden = True


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Louis" wrote:

Hello

I need some help. In a sheet i have around 350 rows.
how can i hidde the rows from 1 to 35 or 70 to 105 to get just what i need
to see and not all the other cells.

Is there a VBA or vbe programming code available ?

Thanks for your help

louis