quick lil macro

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

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

--

HTH

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


"ChasePenelli" <ChasePenelli.1reuii_1120086347.852@excelforum-nospam.com>
wrote in message
news:ChasePenelli.1reuii_1120086347.852@excelforum-nospam.com...
>
> 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
>

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
>
>