Macro Printing Series

[Leppy]

Hello,

Is there a way for a macro to print 2 cells in a series sequence with option on what number range I will print it.

Example.

A1 will print numbers from 2 4 6 8 10 12 14 16 18 20.

C1 will print numbers from 1 3 5 7 9 11 13 15 17 19.

 

[Logit]

Huh ?

 

[Joe4]

Welcome to the Board!

Please provide us with a bit more details on how you expect this to all work.

How should it know how far in the series to go?

How should it determine the series?
Generally, just giving the first two numbers in a series may not be sufficient to determine what the series is.
For example, if the first two numbers in a series were 1, 2, the series could be:
1, 2, 3, 4, 5, ...
or
1, 2, 4, 8, 16, ...

Should the macro prompt the user for which cell to put this series in?
If not, how is that to be determined?

 

[Leppy]

Welcome to the Board!

Please provide us with a bit more details on how you expect this to all work.

How should it know how far in the series to go?

How should it determine the series?
Generally, just giving the first two numbers in a series may not be sufficient to determine what the series is.
For example, if the first two numbers in a series were 1, 2, the series could be:
1, 2, 3, 4, 5, ...
or
1, 2, 4, 8, 16, ...

Should the macro prompt the user for which cell to put this series in?
If not, how is that to be determined?

Macro will prompt user for the range number. ex 1~20
That range number will be the series numbers.

In my case, there are 2 cells that need to make changes.
Like in cell A1 and B2 must be in sequential order from the range number input.
the range number is also the number of copies needed.

I hope I made it clear.

 

[Joe4]

Macro will prompt user for the range number. ex 1~20
That range number will be the series numbers.

In my case, there are 2 cells that need to make changes.
Like in cell A1 and B2 must be in sequential order from the range number input.
the range number is also the number of copies needed.

I hope I made it clear.

No, not so much.
Please remember, that while the problem is very familiar to you, all that we have to go on is what you share with us here.
I think it would be best if you could provide us with a complete example, from start to finish, showing us exactly what you are working with and what you are trying to accomplish.

Note that MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

There is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.