Hiding columns conditionally

J

Jhojho

Joined
Jul 25, 2006
Messages
1
Reaction score
0
I have a worksheet with cells G5 to M5 displaying years '2005' until '2011'.
I want to hide columns G to M in function of the value of N5. If N5 equals 2005, then hide them all, if N5 equals 2006, then hide columns H to M, if N5 equals 2007, then hide columns I to N, and so on, until 2011.
Is there any way to do this with a macro?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement but in code 3
Please help with my Macro! 0
Help with my VBA and formula 8
Hide columns based on related cell 4
Trouble with Cutting and Inserting a Range 2
lookup question 1
Locking cell if sum of other cells is 0 1
Macro to hide column based on header name 6

Top