Hi Dad7

Look n the VBA help for resize

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dad7" wrote in message ...
In Excel can any one tell me how i change the size of an Array, it is set at
1E to E22, i would like to expand this to make it larger ie: 1G to say G99 ??