Previous Topic Next Topic

Macro problem!!!

Closed
TT - Mar 13, 2009 at 07:51 AM
Line32 Posts 31 Registration date Thursday September 18, 2008 Status Member Last seen May 11, 2009 - Mar 14, 2009 at 04:15 AM
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 response

Answer 1 / 1
Line32 Posts 31 Registration date Thursday September 18, 2008 Status Member Last seen May 11, 2009 22
Mar 14, 2009 at 04:15 AM
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.
0

Similar discussions

Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Excel make cell flash red
hugrl -
Rjc -

13 responses