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...
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...
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!
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...
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
'...
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...
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...
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?
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...
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...
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...
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...
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.
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!
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...
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...
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...
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...
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 &...
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 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.