Something like this?

Range("D1:D246").Value = "Bananas"

--
HTH...

Jim Thomlinson


"ChasePenelli" wrote:


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