On Friday, August 30, 2013 1:47:20 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Fri, 30 Aug 2013 01:44:45 -0700 (PDT) schrieb Howard:



Dim myArr As Range

Dim j As Range

Dim i As Long



try:

Dim myArr As Variant

Dim i As Integer



j is not needed





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Okay, not sure why I included j. It's in the other code you posted but so far I've only copied the first.

Howard