deleting contents of column and hiding them

H

hamad.fatima

have a reference cell A1= current month like ( jan, feb , mar etc)
I have 12 columns JAN- Dec
if A1= FEB, i want a macro to delete the contents in JAN and FEB
columns and hide them .
if A1= MAR , then hide JAN & FEB & MAR and delete the contents in them
.. And so on.

Please help me write this macro.

Thanks
 

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

Like to start using Access 1
2 dimensional date sort 2
Delete the contents of columns if the month changes 0
How to avergage colums 7
Function Problem 6
sum columns between certain dates 1
Summing a non continuous range 7
Find the position of a date 6

Top