Macro problem!!! [Closed]

Report
-
Posts
31
Registration date
Thursday September 18, 2008
Status
Member
Last seen
May 11, 2009
-
Hello,

Can anyone help me with the following problem I need to build a macro that can do these steps.

step 1: the macro has to start when cell B49, B51, B52 OR B53 changes
step 2: make a selection of cells B58:D69
step 3: delete cells that have a formula-output of zero
step 1 and 4: the macro has to be undone when one of the cells in step 1 is changed again.

the formulas deleted in step 3 need to return when you change the content of the cells mentioned in step 1.


I'm not really a macro-miracle so any help is welcome

Thanks Tijn

1 reply

Posts
31
Registration date
Thursday September 18, 2008
Status
Member
Last seen
May 11, 2009
22
hi,
check out these links to get help:
www.tutorialized.com/tutorials/MS-Excel/Macros/1
spreadsheets.about.com/b/2007/02/15/excel-macro-tutorial.htm
you will get tutorials to help you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!