![]() ![]() Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Dennis has been developing Excel solutions for over 20 years and is also the coauthor of "Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA and. NET Framework solutions for Excel and Excel Services. 'Unhide the column, and then find the next X.ĭennis Wallentin is the author of VSTO &. If there is at least one, begin the DO/WHILE loop. This example finds all the cells in the first four columns that have a constant "X" in them and unhides the column that contains the X. Loop While Not m_rnFind Is Nothing And m_rnFind.Address m_stAddress 'Hide the column, and then find the next X. Set m_rnCheck = m_wsSheet.Range("A1:D1").SpecialCells(xlCellTypeConstants) 'Search the four columns for any constants. Set m_wsSheet = m_wbBook.Worksheets("Sheet1") Sample code provided by: Dennis Wallentin, VSTO &. I would like to avoid manually unhiding columns in several Excel sheets. Once I manually unhide the column, it is read, and so is teh following column. ![]() This example finds all the cells in the first four columns that have a constant "X" in them and hides the column that contains the X. Right now, when I read in an Excel sheet (using DDE), the hidden column is not read, and the column that follows it (with string characters) is not populated. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |