How to AutoFill

**tpowell55** · 07-02-2010, 12:20 PM

Hello,

I would like to know how one would:
Select the contents of one cell and autofill it to the next. I was thinking something along the lines of:

ActiveCell.AutoFill Destination:=Range.Offset(0,1), Type:=xlFillDefault

Any help would be greatly appreciated. Thank you.

**shg** · 07-02-2010, 12:28 PM

And did that work for you?

**tpowell55** · 07-02-2010, 06:41 PM

Unfortunately not..

**tpowell55** · 07-02-2010, 06:43 PM

I think the problem may lie in the

Type:=xlFillDefault

but I'm not sure. Any ideas?

**foxguy** · 07-03-2010, 11:57 AM

Hi tpowell55;
From Help:
Destination Required Range object. The cells to be filled. The destination must include the source range.

don't use:
        ActiveCell.AutoFill Destination:=Range.Offset(0,1), Type:=xlFillDefault
instead use:
        ActiveCell.AutoFill Destination:=Range.Offset(0,0,0,2), Type:=xlFillDefault

Thread: How to AutoFill

Thread Tools

Display

How to AutoFill

Re: How to AutoFill

Re: How to AutoFill

Re: How to AutoFill

Re: How to AutoFill

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions