Thread
:
Hide Columns Using Numbered References
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
Posts: n/a
Hide Columns Using Numbered References
Columns(MyCount & ":" & MyEndRange).Hidden = True
wrote:
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
--
Dave Peterson
Reply With Quote