Hide a dynamic table range in macro

[beca]

Hi there

I am trying to write a macro to hide a dynamic table range, my code is as below:

Sub Hide()
Range("PART2").Select
Selection.Hidden = True
End Sub

This code doesn't work, can someone tell me what is wrong with the code? and please tell me how to hide dynamic table range in macro.

Thank you very much.

 

[Jerry Sullivan]

Hi beca,

You'll need to hide the range's Rows and/or Columns separately.

Sub Hide_Rows()
    Range("PART2").EntireRow.Hidden = True
End Sub

Sub Hide_Columns()
    Range("PART2").EntireColumn.Hidden = True
End Sub