Complicated macro-problem, please help

Tijn

New Member
Joined
Mar 13, 2009
Messages
2
Hello everyone,

I'm very new in using macro's but i need them now very much.
can anyone tell me how to write the following macro?

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 4: the macro has to be undone when one of the cells in step 1 is changed again.

Is this possible??
Very much thanks!!!!!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

StevenD

Active Member
Joined
Nov 17, 2004
Messages
262
Hi Tijn,

Step 3: - Which cells are being checked for being equal to 0? Also deleting them will mean that the formula will be deleted also.

Can you provide a little more information please.
 

Tijn

New Member
Joined
Mar 13, 2009
Messages
2
the cells in the selection B58:D69 that have output 0 have to be deleted and so forth the formulas as well. But when one of the cells B49, B51, B52 OR B53 is changed using a drop-down list, the macro has to undo the deletion of the zero's (and the formulas as well).

By changing one of the cells in step 1, the output of the formulas will be different and so the deletion of cells in step 3 will be different.

I hope you understand this enough, my english isn't perfect
 

Watch MrExcel Video

Forum statistics

Threads
1,122,232
Messages
5,594,962
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top