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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,211,744
Messages
6,103,670
Members
447,876
Latest member
rodqntr

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
Back
Top