delete cells

  1. G

    Advice on using VBA to delete cells on a worksheet

    Hi to all I am a novice at VBA and what I have done in the past has been by trial and error Usually I succeed but I am totally stumped by the following. Can anyone help? I have a workbook that contains a sheet called “001 Help Sheet”. This sheets contains a list of employees in three columns...
  2. P

    VBA Question: how to delete cells from a flexible array, resulting in a smaller array

    Hi dear helper! I would like to get some help with this VBA problem i am facing: In excel i drew 5 times (columns of) 250.000 numbers from a N(0,1) distribution and manipulated them in a certain, necessary, way. So my basis are 5 columns (A,B,C,D,E) with 250.000 numbers, the numbers are...
  3. S

    A challenge for you... End of the month plus more!

    Hey guys..this is a bit complicated so bear with me but it should be a suitable challenge for you experts! I basically need to know what will be outstanding at the end of the month that is OVER 45 days (at the end of the month though..not now!) The issue is that the end of month command isn't...
    • slay0r
    • Thread
    • age data beginning of month delete cells end of month
    • Replies: 8
    • Forum: Excel Questions
  4. B

    Delete Cells Within Column of Active Worksheet Based on Lookup List of External Workbook

    I'm trying to find some VB code to help me delete cells within a specified column of my active workbook by referencing a list in another workbook. Specifically, I want to delete all cells in my current worksheet that contain traditional personal email URLs such as "@gmail.com", "@comcast.net"...
  5. A

    Duplicating cells from a column

    Hi, I have looked on this site and have found a lot of posts for duplicating cells when you have dupliactes in a row but not when your trying to duplicate from a column, attached is an example of what I mean <TBODY> <TBODY> A B C D E 654321 654321 678900 678900 678900 765432 876543...
  6. S

    Deleting all cells that contain any cell from another sheet

    Thank you in advance! I certainly appreciate the help with this. Using Excel 2003, I have a huge list of one word text that are all in the first column. I also have a "Do not use" list that has a smaller list of one word text all i nthe first column. I want to be able to (without using VBA)...
    • SirHart
    • Thread
    • cells from 2 lists delete cells delete from list do not use lists
    • Replies: 8
    • Forum: Excel Questions
  7. U

    Null vs. Blank

    I am trying to select all blank cells. im not sure how or why (must be a result of lots of copy/paste) many of my blank cells are not highlighted when I do the function: find>go to special>Blanks>OK not sure how to fix this problem....the spreadsheet is huge and i need to select and delete...

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