Hi,
Could anyone give me guidance on vba code for deleting rows where there is no data, I have about 500 lines of data where a blank may appear several times which I need to delete. I also need the loop to end when 20 blank lines are found as this should be the end of the data.
Much appreciated
Could anyone give me guidance on vba code for deleting rows where there is no data, I have about 500 lines of data where a blank may appear several times which I need to delete. I also need the loop to end when 20 blank lines are found as this should be the end of the data.
Much appreciated