cell value = 0

  1. R

    Delete row based on cell value present in same row and different colums

    Hi everyone, i need delete the row based on cell value which is in multiple columns, criteria is delete the row if the value is Zero in all the columns from A to L. thank you
  2. M

    MRound VBA formula setting all cell values to zero

    Hi All, Thanks in advance for any help you can provide. I have a formula in VBA which rounds the values in a range to the nearest 0.5. It works fine but it also sets all the cell values to zero if they are blank, does anyone know a way to get past this? My code is: For i = 5 To 20...
  3. R

    Macro that selects a dynamic range until the cell value turns 0

    Hi I need a macro that would do a range selection based on the call value. my starting cell is A240. I have to select all the cells in column A until it sees a cell value 0. As soon as the cell value 0 is encountered the selection should only select until the previous cell. And then it...

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