AutoFill method of Range Class Failed

[s_simon]

I have formulas in ever cell from J3 thru BH3

Worksheets("Master_Week").Range("J3").Select
Selection.AutoFill Destination:=Range("J3:BH2560"), Type:=xlFillDefault

However the above code fails. Any ideas? Thanks

 

[Joe4]

If you aren't already on the sheet, it won't work.
Try this:

Sheets("Master_Week").Activate
Range("J3").AutoFill Destination:=Range("J3:BH2560"), Type:=xlFillDefault

 

[s_simon]

If you aren't already on the sheet, it won't work.
Try this:

Sheets("Master_Week").Activate
Range("J3").AutoFill Destination:=Range("J3:BH2560"), Type:=xlFillDefault

Still the same issue

Sheets("Master_Week").Activate
Range("J3").AutoFill Destination:=Range(newCol), Type:=xlFillDefault

I have a watch on newCol and can confirm that it is equal to : J3:BH2237
I have tried: Worksheets("Master_Week").Active = Failed
also Worksheets("Master_Week").Range("J3")... = Failed

 

[Fluff]

What about

With Sheets("Master_Week")
   .Range("J3:BH3").AutoFill Destination:=.Range("J3:BH2560"), Type:=xlFillDefault
End With

 

[s_simon]

What about

With Sheets("Master_Week")
   .Range("J3:BH3").AutoFill Destination:=.Range("J3:BH2560"), Type:=xlFillDefault
End With

That's it!!

I knew that I needed the range first - not sure why I was thinking I only needed the first cell of the range

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Joe4]

Odd. The first reply I posted seemed to work on my home computer (using Excel 2016), but not on my work one here (using Excel 2010).

 

[Fluff]

Sounds like MS have changed something, as it doesn't work in 2013 either.

 

[Joe4]

Sounds like MS have changed something, as it doesn't work in 2013 either.

It worked...
I didn't look closely to see if it did the right thing (and not copy the formula from J3 to all the other cells), but it populated the cells and didn't error out.
I am curious to actually check closer and see if it copied the formulas correctly. Maybe I will check again when at home.

 

[s_simon]

2016 here.

I still thank you both for your input