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 23
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.

Similar discussions

Automatically update a cell with last modified date and time
NazCarr -
NazCarr -

2 responses
macro to compare two excel sheets
annajins -
Aks -

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

1 response