PDA

View Full Version : Solved: Hide columns



Rejje
11-22-2010, 01:19 AM
Hi! I've got a problem. I would like for a sub to check if a cell called V_40100 says "TRUE".

IF TRUE: Hide columns; get columns to hide in a cell named V_40200 (value=22:32) in worksheet "Post".

IF FALSE: Unhide above columns

Anyone got an idea?

Bob Phillips
11-22-2010, 01:25 AM
Columns(Worksheets("Post").Range("V_40200").Value2).Hidden = Range("V_40100").Value2

Rejje
11-22-2010, 11:49 AM
Columns(Worksheets("Post").Range("V_40200").Value2).Hidden = Range("V_40100").Value2


Works Perfectly! Thanks!