ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Microsoft Web Components In VB (https://www.excelbanter.com/excel-programming/285450-using-microsoft-web-components-vbulletin.html)

sharon

Using Microsoft Web Components In VB
 
I'm using Excel spreadsheet control in my VB application,
How can I select some columns and group them together ?
In Excel worksheet, you should write this:
Columns("A:C").Select
Selection.Columns.Group
But what should I write in VB to get the same result ?

Thanks, Sharon.

Jim Rech

Using Microsoft Web Components In VB
 
The spreadsheet control does not support Excel's Group and Outline features
unfortunately.

--
Jim Rech
Excel MVP




All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com