# Macro Printing Series

#### Leppy

##### New Member
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.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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

##### New Member
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.

Replies
2
Views
38
Replies
2
Views
114
Replies
1
Views
103
Replies
8
Views
74
Replies
9
Views
112

1,127,328
Messages
5,624,036
Members
416,007
Latest member
csf

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back