You can call it anything you want as long as you dim it as variant as shown.

The ampersands build a string to help you see what is contained in each
element of the array. It has nothing to do with functionality. It is an
example. All you need is

Dim Groups as Variant
Groups = Selection.Value

Assuming Selection is a single area range.

--
Regards,
Tom Ogilvy


"Gary" wrote in message
...
It pointed me in the right direction, At least of got a starting point
thankyou (some of the bits in there I didnt understand (Why the &
signs?)
and Does it need to be called vArr could I call it somethin like Groups?

Thankyou for your help so far

Gary


In article m,
says...
I am selecting a table on a worksheet, making it active and then using
the Selection.array (I did find how to do this in the help files a few
days ago BUT didn't make a note of it, now I cannot find it again.)
I though it was 'Selection.array'

Gary