.range.autofilter

  1. M

    Delete Table Rows

    I am wanting to delete the visible rows in a table where a filter has been applied. This is what I'm using at the moment With Sheets("Events").ListObjects("tbl_EventItems") .Range.AutoFilter Field:=1, Criteria1:=strEvent .DataBodyRange.SpecialCells(xlCellTypeVisible).Delete...
  2. W

    Automation Error. Exception occured (possibly a memory issue?)

    Hi Experts, I wrote below code in a form for my team. It's a simple 'open file - copy - paste' exercise but for some reason a bunch of users are getting these random Automation Errors. I believe it happens when two big files are opened. Some users fix this after a restart and I had one user...
    • wist
    • Thread
    • .range.autofilter look.cellsi partner rec rec.sheetsone
    • Replies: 8
    • Forum: Excel Questions
  3. K

    Infinite loading time when autofilling table?

    Hello everyone, I have an issue during the autofulfillment of a table, with the following code that triggers an infinite loading time, it reaches 100% and then loops again to 0%, it's really frustating. The columns only has about 2000 rows? With ActiveSheet.ListObjects("Table2")...
  4. K

    Check if Table1 contains a certain column header name/value?

    Hello everyone, title says it all. I have a working code but the problem that it's targeting at cell E1 rather than the whole table which is what I want. Any ideas? question1 = MsgBox("example message box message", vbQuestion + vbYesNo, "title example...") If question1 = vbYes Then...

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