delete a range of cells

Hi, I have written a sub with the purpose of finding rows based on a critieria, copying the rows to another worksheet and deleting the original row. The code: Sub MoveToIgangvaerende() ' ' Flytter opgaven til sheetet Igangværende projekter ' Dim i, j, Index As Integer Forfra: For i = -1 To...

I have a large amount data with dates in 2 columns (example below). I am trying to build a macro where it can detect the blank cells and then delete the blank with the corresponding date. I am able to delete the blanks but I can't get rid of the dates so my data will be skewed with missing data...

I'm trying to build a workbook that builds a query table based on a user's entry of a parameter and have this change when they enter a new parameter. I've built the macro so that it's structured like so 1) clear any existing data 2) get data from report 3) copy and transpose it to another...

I am almost pulling out the white flag and surrendering to my evil enemy Macros. I am hoping that there is someone out there who can help me with How to I write a macro that will check rows on a worksheet to see if Column B is blank and if found it will delete the row regardless of what data...

Hi Guys I'm using the following code to delete empty rows But its only works on entire row. How to change the code so it will delete only first 10 cells that are empty. In other words, instead of deleting all row no 4 (for instance) It will only delete "A4:J4". and on.. and on.. Many thanks...