Lost part of sheet

[Pepestru]

I might have hit a wrong key or button, which caused a part of the current sheet not being displayed.
First column shown is C, but cols A an B are still in the sheet.
How can I get cell A1 in the left hand corner again?
Thanks for your help.
Paul

 

[Andrew Poulsom]

Select column C and drag to the left until the little yellow box says 3C. Then choose Format|Column|Unhide.

 

[Pepestru]

Andrew, thanks.
Your suggestion works, but the problem returns after running a macro.

 

[schielrn]

Can you post your macro code? Is there something in the code that would be hiding those columns?

 

[Pepestru]

I hit Enter, but had not yest finished............
I use two macros; one includes the following lines:
Columns("C:H").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
You see columns A and B are not hidden, but are not shown after running the macro. This did not happen before, but started after making changes to the sheet. The macro was not changed.
Maybe this better describes my problem.
Regards, Paul

 

[Jonmo1]

I use two macros; one includes the following lines:
Columns("C:H").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select

Well, that code isn't doing it. Can you post ALL the code?

 

[Pepestru]

Here both macros:
Sub Tonen()
'
' Tonen Macro
' Macro recorded 8-12-2006 by strucks
'
'
Columns("B:W").Select
Selection.EntireColumn.Hidden = False
Range("A1").Select
End Sub
Sub Verbergen()
'
' Verbergen Macro
' Macro recorded 8-12-2006 by strucks
'
'
Columns("C:H").Select
Selection.EntireColumn.Hidden = True
Columns("J:O").Select
Selection.EntireColumn.Hidden = True
Columns("Q:V").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
End Sub
Macro 'verbergen' hides the columns, and macro 'tonen' unhides the columns.
Until yesterday they worked fine. That is why I think the problem is not the macro........ but I am not an expert in macros.
Thanks for your help
Paul

 

[Pepestru]

I have found the cause of the problem! In the macro the columns C:H are hidden, but in my sheet the cells A1 to D1 (Header text) have been merged. This caused a no show of columns A and B after after hiding columns C:H. I have to find another solution for my header text....
Thanks anyway.
Regards,
Paul

 

[schielrn]

Instead of merging the cells, right click on the cells and click format cells and then on the alignment tab, choose center accross selection I believe on the horizontal drop down?

Hope that helps.

 

[elisaleach]

Select column C and drag to the left until the little yellow box says 3C. Then choose Format|Column|Unhide.

I tried doing this to unhide a column in a workbook i am working on yet i cannot make Column A appear. i even highlighted the two columns, A and B and cut and pasted them; The problem is that Column B is still the first column - i cannot get column a to show