Create table x by y

[bodyengineer]

I need to create a table of x and y values that go from 0 to x and 0 to y given x, y, delta_x, and delta_y values. Is there an easy way to automate this either with a built in function or VBA?

e.g.

input: x=3, y=4, delta_x=delta_y=1
output:
__x
y 0 1 2 3
0
1
2
3
4

[vichopalacios]

Hi there

Do you want to create "the table" ...(what goes inside?)
or just the row and column titles? like this image

Capture.JPG

[bodyengineer]

Ultimately I would like to fill out the table as well.

Like the attached image, extending the x and y dimensions to a given end value and filling the table with the atan formula.

Capture.JPG

[vichopalacios]

try this code

Please Login or Register  to view this content.

Hope it helps you