delete row

This is my first post, so I apologize if this has already been answered, but I've searched high and low without finding a solution. I have a number of worksheets with separate lists in them. Each list essentially has items in one column and values for those items in an adjacent column. The...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

Is it possible to compare data in a range of cells to a concatenated variable in vba, if it is found then delete the entire row, otherwise do nothing. For example, range is A:A, value to be located is B27_3/17/2010 variables are test1 and test2 test1 = B27 test2 = 3/17/2010 the concatenated...

Hi, My workbook needs to be completely 100% protected from its user. So I have created a macro/userform that enables them to enter new data into the table. What I need now is another macro that will give them the option to delete any row of data that they have previously entered. I figure...

Would anyone happen to know of or have a cut and paste macro?! Within my current workbook, I have 4 tabs. I would like data to be cut and transferred from the Data tab to the Leavers tab when column M (within the Data tab) is populated with the word "Yes", subsequently shifting the data up one...

Hope one of you with more knowledge of VBA can help. The function of my macro is simple: delete e number of rows from a sheet. This only when macro is activated from the right position. Can you please give advise for the statements of the do-loop: ------------- Sub Clearsheet() ' Dim c As...