ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hideing columns (https://www.excelbanter.com/excel-programming/388285-hideing-columns.html)

Curt

hideing columns
 
does hiding columns effect operation of VBA code? Does the code still count
the columns even tho hidden? Not experienced greatly in code writing. If code
still counts hidden columns I can handle my problem.
Thanks

Don Guillett

hideing columns
 
You can test yourself

Sub countcols()
MsgBox ActiveSheet.Columns.Count
End Sub
--
Don Guillett
SalesAid Software

"Curt" wrote in message
...
does hiding columns effect operation of VBA code? Does the code still
count
the columns even tho hidden? Not experienced greatly in code writing. If
code
still counts hidden columns I can handle my problem.
Thanks




All times are GMT +1. The time now is 12:33 PM.

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