In article , "Jim Cone" wrote:
Bruce,
Selecting cells in advance tends to prevent overwriting cells that you don't
want overwritten.
The code can be changed fairly easily to start from whatever cell is selected
and fill below it.
First see how the code I posted works for you and advise.

Ah. Then the good news here is that my use is for file creation (so we can
use them as mailmerge data for word to make labels) rather than making
changes to an existing file. :)
I'm hoping to automate this entire process using data from another sheet,
but was struggling with the basic 'list of numbers' problem.
Will probably try your code after Easter and will get back to you then.

Thanks :)




"Bruce Sinclair"
wrote in message ...

In article ,
"Jim Cone" wrote:
Here is some quickie VBA code that worked a few times.
Select the cells that receive the numbers and run the code...

Thanks Jim. I will give that a go ... but I should say that part of what I'm
trying to avoid by using the minitab method is selecting cells (with only 32
x 72, I'm already at <quickly checks ... 2304 lines. :)
Hmmm ... a thought. Selecting a range of cells is relatively easy in VBA
isn't it ? I could add a 'select range' function just after the start
number/repeat number input, yes ? Then it would be self contained and much
more useful. :)

Thanks again.