thanks but it doesnt seem to work for a range despite it working for a column
as your example shows
thanks again

"Office_Novice" wrote:


Columns("C:C").Hidden = True


"Atishoo" wrote:

Sorry to ask such a no brainer !!
How do i set a range as visible or not visible like you would an object?

ie range ("main board") visible = false