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 most likely no translated for the 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!
