| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
![me[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
