Hide Columns Using Numbered References

J

jrew23

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
 
Top