K
Kristine
Hi,
I do not have much experience in macro programming, but now I would need to
make a macro. Can someone please help me??
In one excel worksheet called "Menu" I have put a lookup function in cell
(A5). This function presents values 1 to 12 (and cell B5 has a similar lookup
function presenting month January to December), depending on value chosen in
a drop down list. If value in cell A5 is 1 (January in cell B5), I would like
to hide some columns in another worksheet called "Output", say columns U to
Z. I think that for hiding the columns I can use:
Columns("U:Z").Select
Selection.EntireColumn.Hidden = True
But I don't know how to start this macro, I don't know how to do the
selection of columns depending on the value in cell A5(can I use an IF
function?), and how to select the worksheet "Output"?? Can someone please
help?
Thanks a lot,
Kristine
I do not have much experience in macro programming, but now I would need to
make a macro. Can someone please help me??
In one excel worksheet called "Menu" I have put a lookup function in cell
(A5). This function presents values 1 to 12 (and cell B5 has a similar lookup
function presenting month January to December), depending on value chosen in
a drop down list. If value in cell A5 is 1 (January in cell B5), I would like
to hide some columns in another worksheet called "Output", say columns U to
Z. I think that for hiding the columns I can use:
Columns("U:Z").Select
Selection.EntireColumn.Hidden = True
But I don't know how to start this macro, I don't know how to do the
selection of columns depending on the value in cell A5(can I use an IF
function?), and how to select the worksheet "Output"?? Can someone please
help?
Thanks a lot,
Kristine