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
:-)
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,
Just use the fill handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Hi again
HTH![]()
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
Carim
![]()
Thanks guys that has helped me great
:-)
No problem
Glad you got it sorted
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks