Help with spread sheet (Hard to explain)

Hi

I would like to make a spread sheet where i enter the following text


FREE DOMAIN NAME
FREE DOMAIN NAME
FREE DOMAIN NAME
FREE DOMAIN NAME
FREE DOMAIN NAME
FREE DOMAIN NAME
FREE DOMAIN NAME

Which scools down about 100+ but then i would like the spread sheet to be able to add the letter 1 after then the number 2 and so on like this

FREE DOMAIN NAME 1
FREE DOMAIN NAME 2
FREE DOMAIN NAME 3
FREE DOMAIN NAME 4
FREE DOMAIN NAME 5
FREE DOMAIN NAME 6
FREE DOMAIN NAME 7

And so on upto about 4000, is there a way i can do this as i don want to enter each number in manually

Thanks

Kerr

Thanks

I still dont get it

Can some one give me a step by step guide please

:-)

VBA Noob ' s formula is perfect ...

Position your cursor in any cell of row 1... best place cell A1
Type formula
="FREE DOMAIN NAME "&ROW()
press enter

Then place yourself in cell A1
Edit Copy
go down
Edit Paste

Does it work ...?

HTH
Carim

Thanks guys that works :-)


Is it possible for some way to be able to instead of having to cut and paste manually a way where it can be done automaicly upto a line of 10,000 with a macro or something,

Anyone help please

:-)

Hi again

Sub Copy()
Dim i As Integer
For i = 1 To 10000
Cells(i, 1).Select
ActiveCell.Formula = "= ""FREE DOMAIN NAME ""&ROW()"
Next i
End Sub

HTH
Carim