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!!!!!
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,160
Messages
5,835,725
Members
430,383
Latest member
Kastore

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