delete cell

  1. M

    Macro call on delete

    I can make my macro call work with an entry of zero, however, I would like to make it work upon "Delete"!!! Any Suggestions???:confused:
  2. A

    Delete cell content in entire workbook if background color is yellow

    I am looking for a vba code that would delete the content of a cell based on its background color. My workbook has several worksheets in which cells have a light yellow background if the user can input in them. Now I created a button which would reset the entire model, ie delete the content...
  3. V

    How can I resize excel sheet to fit to my use.

    Hi Friends, I have an excel sheet in which I am using only A1:G32 cells. Rest all of them are blank and of no use to me. I this possible that I can remove them completely so that they shouldn't appear at all on the sheet instead of remaining blank.
  4. R

    Message Box upon delete command

    Hi, I am looking for a macro that will load a message box everytime a user of a spreadsheet wants to delete a cell or selection. Basically, if you try to delete a cell, before the clear contents command is carried out, a message box pops up and asks if you wish to delete the cell or not...
  5. B

    Find reference errors and delete

    Hello, As a beginner I am having a tough time writing out some VBA. I am attempting to write out a macro that will find all reference errors within a range, select those cells along with the cell immediately adjacent to the left, and delete them (shifting cells upward). Can anyone help?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...