Welcome to the Tweaking4All community forums!
When participating, please keep theĀ Forum RulesĀ in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For exampleĀ “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post willĀ not bring you to the same post, in Dutch, as there is no translation for that post!
Ā
So basicly i have code : its 2 dimensional masive
Dim x As Integer, y As Integer
x = InputBox("Rows!", "ceturtaislabors", "10")
y = InputBox("colons!", "ceturtaislabors", "10")
b = 2
j = y
d = y
a = 1
For i = 1 To x Step 1
Cells(j, i) = a
a = a + 2
j = j + 1
Next
For i = 2 To x Step 1
Cells(d, i) = b
b = b + 2
d = d + 1
Next
End Sub
which makes my thingy go likes this, it starts from 10th row, but i have to make it start from 1st row? Any recomendatios?
its suppost to look like in the last pic, how can i moveĀ it up? :D
Ā
I think, while taking a quick glance at it (I don't know what numbers you entered for x and y - I assume 10 for both) that you have to change this:
j = y
d = y
to
j = 1
d = 1
Ā
Thank you very much :)
Did it work? 😊Ā
👍Ā Cool!
