clear row

  1. V

    VBA - Clear contents of a row, dependent on a cell's value

    Hi Guys. I'm looking at creating a VBA code to look for the value in 'J' Column to change to "Yes". When it changes, I'd like it to clear all values to the Right (K to AH) in that particular row (leaving formulas in "Y", "AA" and "AC"). it would also have to check every row in the workbook...
  2. S

    Clear row based on column value

    Is it possible to construct a VBA code to clear a row based on a column value? The current worksheet I am using requires the end user to populate column C, which ranges from C14:C50 with one of the following values: Current Leaver New Joiner If either current or new joiner is selected, say...
  3. D

    VBA code to put the active cell as first clear row.

    I want to be able to press a button, and for the active cell to go to the first clear row in column A. The VBA code is what i want, Thanks, Dan.
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.

This Week's Hot Topics

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