-
Retrieving hidden columns
Hi All,
I prepared an Excel spreadsheet with data in columns A to D. Later on data was added in the columns E to AZ by others. When the spreadsheet was returned to me, I am not able to see the columns A to D. The spreadsheet STARTS from column E. I tried the operations in the Window menu like "Freeze/Unfreeze" "Split/Remove split" etc. I checked in the Edit menu to see whether I can "undo" something. If someone has deleted the columns A to D, the spreadsheet should still start from col A.
I can see the horizontal scroll bar showing a gap with column E at the start, but by manually bringing it to the extreme left does not show the columns A to D.
Can someone please advise me what could be the problem and what I should do to retrieve my data?
Thanks in advance
-
[VBA]Range("A").EntireColumn.Hidden = False[/VBA]
-
Thanks Charlize, that did the trick.
- Krishna
-
A non-VBA solution.
Select the first visible column and drag the cursor to the left. This selects the hidden columns as well. You can then fix them with Format/Columns/Unhide.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules