![]() |
Hide columns code
Sheets("Layouts").Columns("A:IV").EntireColumn.Hid den = True
Sheets("Layouts").Columns(Range("C38:IV38").Find(S heet1.Range("F4")). _ Offset(1, 0).Value).EntireColumn.Hidden = False Here is my code and I am trying to hide all of the columns except a few. The few are assigned by looking up the value from Sheet1.Range("F4") and looking them up on Sheets("Layouts").Columns(range("C38:IV38") What is wrong with my code? Thanks, Jay |
All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com