Hide Columns Using Numbered References
I'm trying to hide columns in a sheet using references to "numbered
columns" instead of "lettered" columns, but I can't figure out the
correct syntax. Someone please help. Thanks
Sub TestCount()
Dim MyCount
MyCount = Range("A1").Value * 2 + 3
MyEndRange = 256
Columns("MyCount:MyEndRange").Hidden = True
End Sub
|