I am trying to find a way and if possible to concatenate 2 characters so
that they end up being a variable name

For example I want to do something like this.


Sub Test()

Dim A1 as Range, A2 as Range, A3 as range

For N=1 to N

A&N=cells.(1,N).value

Next N

End Sub


Is there a way?

Thanks
Mozart


--
mozart
------------------------------------------------------------------------
mozart's Profile: http://www.excelforum.com/member.php...o&userid=13314
View this thread: http://www.excelforum.com/showthread...hreadid=399345