It is a module level variable as it is declared at the top of th
module. I did this because the function that fills myArray is outsid
of the sub that calls it. I'm not sure why it's giving you a subscrip
out of range error. Make sure that you have the declaration at the to
of the sheet module.
The only way I got Error 9 is if I put the declaration inside the sub.
You can't declare arrays as Public variables.

Where do the rip1, rip2, rip3 etc. need to be placed on the Addres
sheet

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38019