Try:

Sub ShowMeAnA()
With Columns("A:A")
.ColumnWidth = 10
.EntireColumn.Hidden = False
End With
ActiveWindow.FreezePanes = False
Application.Goto reference:=Range("A1"), scroll:=True
End Sub



--
Gary''s Student - gsnu200842


"Ayo" wrote:

I have a sheet where the first column is not showing, column A, and when I
try unhide, that doesn't seem to work. And I think it is creating a problem
when I try to "Move or Copy" the sheet to another workbook.
Any ideas?

This is Excel 2007.