select and remove

  1. D

    Excel 2010: Delete rows based on cell values

    Should be simple but I'm stuck on this: I want to clean up large files by deleting all rows where certain cells do (or dont) contain certain values. I'm fairly new to vba, so I did what I usually do and cobbled up my script from posts here and on other forums, and then resolved the runtime...
  2. G

    Find all occurrences, selecte entire rows, copy entire rows

    I feel like this has or should have been asked a million times, but I can't find the answer. I'm searching a particular column of 10,000+ rows for a word. It finds all instances. I hit ctrl A, and all of those cells are selected... great. Now what can I do? I need to select the entire rows...
  3. F

    Problems selecting the correct data

    Hi all, I am trying to build a macro to perform what I thought was a simple instruction but has turned out to be a nightmare. Scenario: My sheet has filters and I want to remove the listings (15 cells per row) where column 5 filter = 100% I then want it to paste into another sheet and then...
  4. D

    Selecting a Blank Cell

    I was trying to record a macro that selected the first blank cell in a column (A). The problem I am having is that all cells down to row 300 have formulas and the result of the formula may be "". So I want to select the first cell with a value of "" in column A. So I can't record the macro...
  5. B

    Editing data, want to remove brackets

    I've got two large columns of numerical data, some of which have the figure I want + (.....) I want to remove the brackets and whatever it's contents throughout the sheet. Not knowing how long the contents of the brackets are has confused me. I know that the figure I want to keep will...

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