On Friday, February 21, 2014 2:12:49 AM UTC-8, Claus Busch wrote:
Hi Howard,



Am Fri, 21 Feb 2014 02:04:50 -0800 (PST) schrieb L. Howard:



This clears the A column cell, where I presume there is no 'Cut' available in an array, so that cell is still occupied until cleared.

myArr(i, 1) = ""



no, myArr(i,1) is not cleared. It is a empty string. You can't delete an

element of the array this way

This puts all the new data back into columns A and B. So if the columns were cleared one step ago why would you run another Entire.Delete Row?

Range("A2:B" & UBound(myArr)) = myArr



yes, but also the empty strings will be inserted. Therefore it is

necessary to delete empty rows.





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Okay, makes sense now.

Still trying to figure the second 1 in the left portion.

Howard