ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide a cell using Windows Script (https://www.excelbanter.com/excel-programming/313113-hide-cell-using-windows-script.html)

John Doe[_5_]

Hide a cell using Windows Script
 
I have a script that creates and populates an Excel Spreadsheet.

I would like to programmatically hide an entire column from within the
script.

Thanks in advance.

Please post here. No Emails please.



Nick Hodge[_5_]

Hide a cell using Windows Script
 
John

It would be helpfull if you posted the script, but if you have a reference
to the excel worksheet, then it would be something like

xlWks.Columns("A:A").Hidden=True

HTH

Nick Hodge

"John Doe" wrote:

I have a script that creates and populates an Excel Spreadsheet.

I would like to programmatically hide an entire column from within the
script.

Thanks in advance.

Please post here. No Emails please.





All times are GMT +1. The time now is 05:09 PM.

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