Macro to automate page count

[Prinz Jaymes]

Hi Ninjas and friends,
Is there some way to ask Excel to automate page count on a worksheet?

For instance

If I type 250 in a specific cell

Is there anyway, run a Macro whereby I can get from top to bottom.....
Page 1
Page 2
Page 3
Page 4....

till

Page 250.

Please help!

 

[Luke M]

On a slight side note, this thread might be useful for dealing with pages:
http://chandoo.org/forum/threads/macro-to-return-page-number-of-a-named-cell.9787/

For your exact question, not sure what you want the macro to do. If you want page numbering, that is a built in tool under Page Setup.

 

[Prinz Jaymes]

Hi Luke
Sorry if question was a bit vague.

I need a Macro that can run a count of numbers from one cell to another in a progressive manner.

If I type in Cell b2 = 250

Need a Macro that can run from Cell C2 to C251 with numbers 1 - 250 or including a "text" Page 1 to Page 250.

For instance , Cell c3 would be "Page 2"
Cell c4 would be "Page 3"

 

[KenU]

Prinz Jaymes,

I don't think you need a macro for this. Please see the formula-based approach in the attached. It is currently set up to go up to 1000, but could be expanded if needed by simply dragging the formula.

Hope that helps.

Regards,
Ken

 

[Prinz Jaymes]

Magic!!!

I am not that smart but all the more reason why I love coming here..........Thank you KenU!!!

 

[Prinz Jaymes]

By the way, anyway I can get it to start Page 1 from a different row.
So far, its only mimicking the row number.
Need to be able to make it start from any cell.

 

[Luke M]

If you type Page 1 into a cell, right-click the bottom-right corner and drag down. Select Fill Series, and boom! Handy trick for other type of progression as well (days/months/years/etc)