delete a row

Help! I am trying to find a VBA solution to allow users to delete one or more rows at the bottom of an excel table (preferrably one row at a time); i.e. users may have inadvertently added new rows that they now want to delete before finalizing the report. The worksheet is protected. Below is...

I have a macro that I am using and it seems to create an excess of lines at the bottom of the sheet that I not only am unable to delete, but cause me problems when trying to print. (I only want to print pages with information on it not, 150 extra pages with only a cell outline.) Here is what I...

Hi, My spreadsheet is just over 1m rows big, but hs a numbr of corrupt rows in it. I need to create a macro loop, where if the cell in column B says "TEXT", then that row and the 3 below it, need to be deleted. Can anyone help? Thanks

Hi. I'm new to VBA and I've been trying to figure out a way to find a word on a spreadsheet. Once found, I want to delete that row and every row after it until it hits a specific word. Once it hits that word the loop would stop. Any ideas are appreciated. Thanks!

Hello, I need some help troubleshooting. Below is an extensive macro that basically writes data from a user's template to a certain data sheet (in the form of rows) depending on their "service group." There have been 3 separate instances of a user saving data and instead of adding rows onto...

Before we dive in, my knowledge of macros extends to the point where I can tweak already written codes to suit my needs. I've searched all over but this one is still throwing me for a loop (no pun intended). I'm in Excel 2010, Win7. I am trying to build a budget forecast based on revenue vs...

Hello there I have been asking questions and never turned down, all answers I got back were perfectly correct and served my purpose, so as usual thanks in advance I have a simple question In excel sheet that contains data in column A:H with column E for amount How can I delete the entire row if...

I would like to delete all rows if the value(test) in column C is not equal to "ADS". I want to do this on multiple files starting with "PD????.xls" in "C:\Prakash" folder. (All file names starting with PD) Could anyone help me with a code for this operation? I am using Excel 2000 and all files...

Hi When I attempt to insert or delete a line from my worksheet, I get an Error 13 (Incompatible type I think would be the translation to english). This is an extract from the routine (which works perfectly well when I don't need to insert a line LOL): Private Sub Worksheet_Change(ByVal Target...

Anyone who could help me. That macro asks if I want to delete or not. If I choose "not" it leaves current cell red. How can I degree that. If I choose not to delete it should leave that cell as it was in the begin. Please help me. Sub oma() Range("A:A").Interior.ColorIndex = xlNone For i =...

Hi there everyone, I am new with excel and currently using excel 2003 and I have been asked by my manager to create an action item list and would appreciate anyones help! I've searched through the forums and I cannot find anything that will help me! What I need is a macro code/button that...

Hi Everyone, I have created a script that deletes a row based on a string found in the first column (referenced to another table with a list of strings to delete) What is weird is that the script works but is not deleting all rows that match the criteria. For example, if there are 10 rows...