ActiveX Excel - how to choose the whole column

[tkdbruin]

Hi,

I can access individual cells in Excel using the Range object but I could not figure out how to select the whole column. Here is essentially what I'm trying to do if I were to do it with a mouse in Excel.

"Select Column A -> right click to choose "Format Cells..." -> Under the Alignmnet tab, click the "shrink to fit" checkbox."

Thank you very much.

Jae-Ho

[Joe_H]

This should work for you.

For more information and some sample VI's and tool kits, you can go to the excel board

Message Edited by Jhoskins on 01-31-2007 07:36 PM

[tkdbruin]

Hi, I'm sorry for the trouble but could you please save it as LabVIEW 7.1? Also thank you for the link to the excel board. Thanks

Jae-Ho

[Joe_H]

Sorry I cannot go back that far. Here is a screen shot.

Message Edited by Jhoskins on 01-31-2007 07:41 PM

[tkdbruin]

Hi,

I just tried it following the diagram but was confused with what the "Column" string control contained to select the whole colmun, say column "A". I can do it to individual cells if I connect "A1"
Thank you.

Jae-Ho

[Joe_H]

In the column string control type in a:a to select the whole column A.