Macro to delete row in filter range works in one workbook, not the other

ret44

Board Regular
Joined
Oct 5, 2010
Messages
147
This was a weird one to me, hopefully there's an easy explanation...

I have a macro to delete a row - typically in a filtered range.

Code:
If ActiveCell.Column = 14 Then

ActiveCell.EntireRow.Delete

Else

    Exit Sub

End If

If Rows(ActiveCell.Row).Hidden = False Then Exit Sub

Do
   ActiveCell.Offset(1, 0).Select
Loop Until Rows(ActiveCell.Row).Hidden = False

I run this exact code (tested code from another workbook to confirm) in other workbooks to delete rows in filtered ranges, but in this one workbook, it will not work.

Edit: I get a "Cannot shift cells in a filtered range or table" error
 
Last edited:

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,224,608
Messages
6,179,872
Members
452,949
Latest member
Dupuhini

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