noobie question
 

Total newbie to VB
Cell A1 =2
Cell A2 = 3

I am looking to create a text array
1x1 in cell A3
1x2 in cell A4
1x3
2x1
2x2
2x3 in cell A8

noobie question
 

What's the link between A2, A3 and the output you need in the other cells
below?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"me" wrote:

Total newbie to VB
Cell A1 =2
Cell A2 = 3

I am looking to create a text array
1x1 in cell A3
1x2 in cell A4
1x3
2x1
2x2
2x3 in cell A8

noobie question
 

Sub ABCD()
Dim rw as Long, i as Long, j as Long
rw = 3
for i = 1 to Range("A1")
for j = 1 to Range("A2")
cells(rw,1) = i & " x " & j
rw = rw + 1
Next j
Next i
End Sub

--
Regards,
Tom Ogilvy


"me" wrote:

Total newbie to VB
Cell A1 =2
Cell A2 = 3

I am looking to create a text array
1x1 in cell A3
1x2 in cell A4
1x3
2x1
2x2
2x3 in cell A8

noobie question
 

To get the 'real' multiplication × rather than letter x use ALT+0215 on
numeric keypad
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"me" wrote in message
...
Total newbie to VB
Cell A1 =2
Cell A2 = 3

I am looking to create a text array
1x1 in cell A3
1x2 in cell A4
1x3
2x1
2x2
2x3 in cell A8