Range("D1").Value = "bananas"
Range("D1").Autofill Range("D1:D246")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ChasePenelli"
wrote in message
...

Just looking for something that i can use to paste teh same text down a
certain column to a certain point. i.e. "bananas" Column D1-D246
and then have it paste it all the way down.

Thanks Guys


--
ChasePenelli
------------------------------------------------------------------------
ChasePenelli's Profile:
http://www.excelforum.com/member.php...o&userid=24619
View this thread: http://www.excelforum.com/showthread...hreadid=383362