noobie question

  • Thread starter Thread starter me
  • Start date Start date
M

me

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
 
What's the link between A2, A3 and the output you need in the other cells
below?
 
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
 
To get the 'real' multiplication × rather than letter x use ALT+0215 on
numeric keypad
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top