I have a spreadsheet that has a table in it with a formula in a hidden column for the table. I have a button to delete the records but if the row is highlighted and delete button pressed on the keyboard, the formula in the hidden column will be deleted. Is there a way I can add some vba code to...
Can anyone help me by writing a macro that can move a zip file from a specific folder, put it in a new specific folder elsewhere on the drive, extract it in that location, then delete the zip?
The delete is the least important part. When it moves it initially it would be best if it was cut...
I am trying to piece meal my VBA where I need it to select all sheets in the workbook and delete the last row in each sheet.
Each sheet has the same headers but varies in row so as long as it is the last row being deleted it will work.
Any pointers would be greatly...
I have an Excel Table with names and abbreviations of names (two columns only).
I would like to prevent users from deleting the header row and last row in the table.
Surname and Initial
3 [given by...
Hi folks, i'm getting a Run-Time Error '1004' "Delete method of Range class failed" for the following code.
Dim MasterSht As Worksheet
Dim ImportSht As Worksheet
Dim LastRow As Long
Dim x As Long
Application.ScreenUpdating = False
Set MasterSht = ThisWorkbook.Sheets("Master...
I've used the code below to move a chart from one sheet to another (from Sheet 5 to cell M2 in Sheet 1).
However, when re-running the code to create the chart, I would like to delete the existing chart in cell M2 of Sheet 1, without deleting the other charts in Sheet 1.
Does anyone know...
Hi to all of you!
Kindly require to provide me support for a VBA code so that to run through columns "O", "P", 'Q" and where the rows are blank or "0" should delete entire rows. Therefore that, the rows "1" - "7" are headings and the code should run from row "8" till rows down. Thank you all in...
Hi all, I searched the forum and found 2 different macros that may work with some tweaking, but is beyond my capabilities.
I need the following scenario to happen:
12000 email list has all info from first name, last name, address, gender, age, email and more. The only columns I am concerend...
Apologies for the simple request as a beginner to the forum, but I would like to have a button on a spreadsheet that I can delete either a specific column or row.
I have code to remove a column as follows:
Dim varUserInput As Variant
varUserInput = InputBox("Enter...
I have data in two columns and would like to delete data in the second column which has the letter 'N' in it, using the auto filter.
The amount of rows will vary.
In the example below, there are only 5 rows and I would like to delete rows 3 and 4, as they're the rows with the letter...
All hi, i am kindly require to provide me a VBA code so that to run through col. "A" and where find the description "NET COST OF SALES/(FOOD)" twice, should delete once entire row but the second one. I present below original data and expected result. Thank you all in advance
I am using a filter to show all "BB" transactions and delete the rest of the rows that are not "BB". Here is what I recorded when I did it:
'Set autofilter on Column E for "BB" and delete all other rows
I have an autofilter on row 13 and then trying to delete all the visible rows
I found somewhere that the below code should work, but it doesn't.
Anyone who could help me crack the code?
Rows("13:13").AutoFilter Field:=5, Criteria1:="22 - Rabobank 370113144"
I have an excel spreadsheet containing many rows copied from VBE.
Some of these contain comments - always with a ' in column 1. I would like to delete these lines, but the ' is a hidden character and the program can not find it.
Any suggestions, please?
Happy Friday. I'm trying to record a macro that filters a table to any rows with a "D" in the designated row and then deletes the visible rows, unfiltering the table before ending the macro.
I am using the below but it is failing on the "Selection.EntireRow.Delete" command - is anyone...
I am in need of some help here. All the VBA Codes I have tried to use don't work.
I am trying to open the information in a pivot table in a new worksheet (I have that part figured out but I cannot get it so it will allow me to add new sheets to my existing workbook every time it opens...