Have you tried this option

--Type 31101234000 in Cell A1
--From menuEditFillseries
--Select 'Series In' as Columns
--Keep the step value as 1
--In Stop Value enter 31101234999
--Hit 'OK'

If this post helps click Yes
---------------
Jacob Skaria


"Basta1980" wrote:

Hi,

I would like to know if it is possible to fill a column based upon input
from a textbox. What I'm trying to do is; ask user to manually input first 8,
9 or 10 digits (fixed line number). Then the user has to choose (with the
help of three buttons) if he/she wants to automatically fill a serie by 10,
100 or 1000. So if a user fills in 31101234 and then click button 'add 1000'
(fictive name), excel fills the serie in column A, Row1 like this;
31101234000 down to 31101234999. And if this is possible, how do I go about?!

Regards

Basta1980