Home » Forums » Open Source Learning Center » Question and Answer

Autofill code

Submitted by Degster on 27 July, 2011 - 17:28
I'm writing code in sheet 1 that does an autofill in sheet 2, but it does not seem to recognize the command. It simply ignores the line and proceeds to the next line of code. 
'ActiveSheet.Selection.AutoFill  _
 Destination:=ActiveSheet.Range("A9:A" & pg_2_dates),  _ 
 'Type:=xlFillDefault

Sheets("WAProInt (2)").Selection.AutoFill  _ 
Destination:=Sheets("WAProint (2)").Range("A9:A18"),  _ 
Type:=xlFillDefault
As you can see, I've added references to the sheet name in the second line of code, but it still doesn't work. any ideas?
‹ turn off 'do you want to save' message Emptying textboxes in a VBA form using a for next loop ›
»
Vishesh's picture

Use Activate

Submitted by Vishesh on 28 July, 2011 - 02:33.
Sheets("WAProInt (2)").Activate
 
Sheets("WAProInt (2)").Selection.AutoFill  _
Destination:=Sheets("WAProint (2)").Range("A9:A18"),  _
Type:=xlFillDefault
»
Vishesh's picture

Instead of selection use

Submitted by Vishesh on 27 July, 2011 - 17:37.
Instead of selection use range as you are in different sheet than the target sheet. 
Sheets("WAProInt (2)").Range("A8").AutoFill  _
 Destination:=Sheets("WAProint (2)").Range("A9:A18"),  _
 Type:=xlFillDefault
»