Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
code to hide hides too much | Excel Discussion (Misc queries) | |||
Hide VBA code help | Excel Worksheet Functions | |||
How to hide VB code from Excel file | Setting up and Configuration of Excel | |||
Hide Code | Excel Discussion (Misc queries) |