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?
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?
[vba]
Columns(Worksheets("Post").Range("V_40200").Value2).Hidden = Range("V_40100").Value2
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Works Perfectly! Thanks!Originally Posted by xld