deleted

  1. T

    Scroll to cell value

    My spreadsheet is set up to scroll from a button to a certain row number. That row contains specific information. However, when new rows are added or deleted, the button scrolls to rows above or below the correct row. I have the following code now: Sub View_9() ' View_Total Macro...
  2. T

    Selection.Delete Shift:=xlUp

    I want to delete contents of some cells and then shift the cells up without modifying formulae in the same rows of the deleted cells. Currently when I delete the cells and move the cells up to replace the deleted cells, any formulae in the rows of the deleted cells are modifed and reference...
  3. Z

    Remove Duplicates from Spreadsheet

    Hi, I am trying to use VB Code to remove duplicates from a spreadsheet based off a column header of "Empl ID". I want the duplicates to be deleted. Thanks!
  4. M

    Deleting Values in a Cell Based on the Above Cell Value

    Hello Folks I am a rookie in excel macro. I need a macro to sort out my issue. If any cell contains text "Name" the letters or numbers before the 1st space should be deleted in the below cell. If anyone able...
  5. Guzzlr

    Delete Cells with Matching Numbers

    Hello All. Sub Delete_Matching_Numbers() Dim lastRow As Long ' Application.ScreenUpdating = False 'Find last row in column B lastRow = Cells(Rows.Count, "B").End(xlUp).Row 'Run Program If Range("B8") = Range("C8") Then Rows.Range("B8:C8").Delete End If '...
  6. L

    Macro to delete rows based on criteria

    Hi, Can anyone help me out with this please? First In the column with status, any records that are not released should be deleted. Then in the external document column, any records that contain DDS, MIN, or Canada should be deleted. I say contain because it could be either DDS by itself, or with...
  7. R

    Workbook was corrupted

    Hello, I was working away on a workbook that I had created a few weeks ago to track sales of a fundraiser. When I went to save it, the screen came all white and it had yellow ! on it in several places. I look at the top of my screen and it said program not responding, so I left it alone...
  8. B

    VBA code to delete all rows when first cell contains a percentage

    Hey, I want to loop through all worksheets and delete all rows that have a percentage anywhere in the first cell of each row. So if it 99.60%, it is deleted, if it is 99.5% it is also deleted. How can I do this just by specifying % and over all worksheets in my workbook?
  9. H

    Erase row if column contains certain value

    Hello, I got this very simple macro that allows user to erase a complete row. It is manually activated by placing cursor in a certain row/cell and executed by CTRL+SHFT+E. Sub Erase_item() ActiveCell.EntireRow.Select Selection.Delete Shift:=xlUp Range("A6").Select End Sub After...
  10. M

    Prevent cells being deleted using VBA

    Hi all, I am in need of a VBA macro to stop a section of cells (F28:J36) from being deleted from a specific worksheet as they have important formulas in them. But I need the cells to be editable. I currently have simultaneous code which automatically hides the rows based on certain conditions...
  11. D

    VBA code that will enter different values into difference cells.

    Hi, I was wondering if someone could help me please? When a number in column A is entered, I would like the following to happen: The number 11 automatically enters in column C and 800 enters into column E. With a value in column A. Once column B is selected I'd like it to call for a userform...
  12. R

    How to run macro when certain cell deleted?

    Hi, i'm stuck with the macro, to run when certain cell deleted. here's the case, user will only fill the yellow area, then column F will have values too. i want to when i press delete/backspace on C6, it'll delete F6 too. but it won't delete, if i only edit the content of C6. so certainly this...
  13. G

    VBA macro to remove rows if column has value?

    Hello, I want to know if theres a marco that can do this and if so, please share. I want rows that contain any value other then 0 to be deleted. Thanks in advanced.
  14. O

    Formula changes when rows are deleted, how to prevent.

    I am using a simple formula such as this: =COUNTA(Sheet1!D2:D20) The problem is that anytime a row is deleted from 1 to 20, the formula adjusts itself. How do I prevent this from happening? I have been tinkering with the INDIRECT function but have had no luck making it work. Thanks!
  15. E

    Dellete column F all the values that dont have 3 digits

    Hope someone can help I am looking for a macro to delete all the values in colum F that dont have 3 digits. here is a sample data so in this sample below 1,3, must be deleted 2,,2 must be deleted. 4,, must be deleted. So only Numbers with 3 digits must not be deleted.Thanks for any help -this...
  16. M

    If value in a cell = 0, then delete dependent cells. Check across Row

    Hey, Friends; I'm having a bunch of trouble with this... In row 2, I have values either 1/0. I'm trying to come up with some VB that would delete the data in rows 4-6 in the column that that 0 is present in. So if b2=0, then b4-6 will be deleted. If z2=0 then z4-6 will be deleted. If c2=1...
  17. D

    Transfer Data from dynamic workbook to database

    I have a general template I use to input client data that is set up so that rows with empty cells in a certain column (i.e., there is no data for particular variable for a client) are deleted. For example, if there is no data entered in say G27 for a variable listed in A27 then row 27 is...
  18. I

    Excel error Sorry cannot find xxxx its possible it was moved

    I was trying to combine 2 excels into one, but i had a lot of formulas and pivot tables, so i decided to transfer the tabs from one excel to the other. My issue now is that the other excel is empty and i deleted it, but now i cannot change the data source of the pivot tables nor create new pivot...
  19. M

    Dynamic Pivot Range - Still counting phantom data?

    Morning, So the xlLastCell in the following code is still counting the last row of data prior to being deleted (hence the dynamic range). Set StartPoint = Data_sht.Range("A1") Set DataRange = Data_sht.Range(StartPoint, StartPoint.SpecialCells(xlLastCell)) NewRange = Data_sht.Name &...
  20. S

    Delete filtered rows in Power Query

    I filtered for the negative numbers and 0s in the column "Sales". I would like to delete those filtered rows. Is there a function in Power Query that allows me to delete this filtered 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