delete visible cells

  1. P

    Delete Visible Cells from Column N onwards

    I have data up to Column Z (this can change) and the data starts in row 6. Row 5 contains headers. I have filtered the data. I would like to delete data from all visible cells from Column J to the last row in the last column. (I would like to keep ALL data in Columns A:I and I would also like...
  2. R

    Activate not Select, Apply special filter and delete visible cells

    Folks, How do I change this code so that it does not have to select the cells, but can activate them instead? 'Delete Filtered Rows Application.CutCopyMode = False Range("a2", Selection.SpecialCells(xlCellTypeLastCell)).Select Selection.SpecialCells(xlCellTypeVisible).Select...
  3. M

    Need Hlep to correct the Code

    Hi Friends, (With hopes of help) I need help one of the codes which I have recorded. I'm getting error when I re-run it. I have two questions 1) Is it possible to move the entire rows to the next sheet with Criteria and only visible rows. ? Or Do I need to copy to next sheet and then come back...

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