hie,
Is there a way to expand and collapse the columns in Microsoft Excel ? If possible then how ? Please somebody give the relevant information or ideas about this feature....
thanks
hie,
Is there a way to expand and collapse the columns in Microsoft Excel ? If possible then how ? Please somebody give the relevant information or ideas about this feature....
thanks
Use the following code according to your needs and check whether you can implement the required feature.
Code:Sub HideG_UnhideG() If Columns("c:j").EntireColumn.Hidden = True Then Columns("c:j").EntireColumn.Hidden = False ActiveSheet.Shapes("toggleit").TextFrame.Characters.Text = _ "HIDE" Else Columns("c:j").EntireColumn.Hidden = True ActiveSheet.Shapes("Toggleit").TextFrame.Characters.Text = _ "SHOW" End If 'can use =not if only ONE change..... 'Columns("g").EntireColumn.Hidden = Not Columns("g").EntireColumn.Hidden End Sub
You don't need VBA at all for this. You just need to use an Excel function called Group and Outline facility.
You can find this facility in the Data menu.
Try this :
- Select the columns you want to be expanded/collapsed
- Data > Group and Outline > Group
hi
can any one guide me how to solve the date format in csv file.
in excel 2010-08-30 or 2010/08/30 suppots but when i converting into csv file it won't accepts.
in csv 2010-08-30 not supports. can any one solve my problem
i am looking for solution.
Microsoft has released a hot fix for that. This is a common issue with most of the user where you date format changes when you export or import data in csv. This issue is applicable to Microsoft Excel. For that go to below link and read some fixing solutions. This might help you or else you can download the hotfix and install the same. This is a vba issue.
CSV Hotfix
Bookmarks