ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide columns code (https://www.excelbanter.com/excel-discussion-misc-queries/185102-hide-columns-code.html)

jlclyde

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