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

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