i have ran it but it has deleted all the data out of the workbooks. I am guessing there are multiple tables with multiple blank lines in my book (i made it in excel and then pasted to Word)