View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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