Macro Printing Series

Leppy

New Member
Joined
Dec 26, 2020
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Some videos you may like

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)

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,562
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Dec 26, 2020
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,562
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top