activesheet.usedrange

  1. G

    Make Table using .UsedRange in VB instead of using cntl-T

    Hi there, I have a worksheet whose data change periodically leading to larger or smaller ranges of columns being used depending on the data. The number of rows are always the same. In my VBA module that gets the data, I would like to make a table (instead of cntl-T afterwards) with the data...
  2. N

    How To VBA Code To All Worksheets?

    I am using this code. Sub CleanUp() With ActiveSheet.UsedRange .Value = Evaluate("if({1},trim(clean(substitute(" & .Address & ",char(160),"" ""))))") End With ActiveSheet.UsedRange End Sub How can I apply it to all worksheets in the active workbook? If there is ever an error...
  3. S

    VBA Multiple <> Filter

    Hello! I'm looking to delete all rows not containing the following in column E. I have the following code, but it's not working. Any ideas? With ActiveSheet.UsedRange .AutoFilter field:=5, Criteria1:=Array("<>PN", "<>RN", "<>DR", "<>TA"), Operator:=xlFilterValues .Offset(1...
    • sachavez
    • Thread
    • .autofilter activesheet.usedrange field=5 ideas working
    • Replies: 3
    • Forum: Excel Questions
  4. Gringoire

    Reduce the UsedRange

    Hi, I have a worksheet called DATA in Excel files (called Master) where I load data from others excel files. Sometimes I need to load a huge amount of data (about 10.000.000 cells) but the most of times I just need about 100.000 cells. The point is that once I loaded a big amount of data...

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