Show Hidden Column A and B

[MikeL]

Hello,

I ran a macro to unhide all columns (which produces the screen shot below)

Problem is the view I see still shows the first column as 'C'. How can I change this view to show columns A and B?

TEMPLATE JUN10 VS JUN09_KV.xlsm
	C	D	E	F
1	category	description
2	revenue	Royalties
3	expenses	Rent
variances +-50k (2)

 

[VoG]

Try

Application.Goto Range("A1"), True

 

[MikeL]

Thanks, the cursor goes there but it still shows the same view.
Any ideas?

Mike

 

[HalfAce]

Have those columns been re-sized (even if by accident) to be too narrow to see?
Try setting the column width to see.

Range("A:B").ColumnWidth = 10

Hope it helps.

 

[MikeL]

Thanks HalfAce and VoG.

Both solutions ended with the same issue. The cursor ended in Column A but only Col C was visible. I couldn't resize the columns to show A and B either.

Here is what ended up working ....
I Selected All in the worksheet, copied and pasted to a blank worksheet in the WB and all is now visible.

Still not sure if there is a better way but this ended up working for me.

Mike

 

[Nalani]

Incorporate this in your code.

Sub test()
With Sheets(1)
    .Columns("A:C").EntireColumn.Hidden = False
End With
End Sub