clearing data

  1. J

    Cell contents will not stay Deleted/Cleared of Data

    I am creating a spreadsheet where I am averaging numbers acrosscolumns B through K. An example of theformula is: (row 23) =IFERROR(AVERAGE(B23:K23),"0") **Formula created in column L** (row 24) =IFERROR(AVERAGE(B24:K24),”0”) **Formula created in column O** This...
  2. B

    Loosing data when unmerging cells

    Hello, Every week I recieve a data report in an excel file. I need to input this data in another program as a CSV file. This file is very hard to work with as there are multiple merged cells and many blank "spacer" rows and columns. I have tried to use a macro to unmerge all the cells and...
  3. G

    vba - ClearContents not working?

    Hi guys, just simple fast one - Any idea why if I put into my code only the first line below, clearing of the whole sheet does not work & if put another one then it is working.. ? Checked for protected, merged etc.. nothing such like this there.. ;o)...
  4. K

    vba code button to clear all; checkboxes, comboboxes, cells, counts, etc...

    Hi all, I am new to vba and i have tried to find a code on here for clearing my whole worksheet but i cant seem to find one which does the specifics i want to or does all the bits :) if i missed something id be very grateful for a thread link... Trying to create a new prf for my team, and i...
  5. A

    I have multiple rows of order data need to move daily to completed order tab

    I want to use column A if there is a number 1 in column A the order is complete and needs to be moved to the last empty row in the completed order tab. I just need a macro to move all completed orders once a day and clear the data that as been moved and move all other rows left to the top of the...

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