Thankyou for your help.
--
glen


"Ron Rosenfeld" wrote:

On Wed, 1 Apr 2009 13:48:09 -0700, Silverline
wrote:

thank you Ron I have it working on a range of cells example B12-B37 how do
now add N12:N37
--
glen


Set AOI = Range("b12:b37,n12:n37")

--ron