Drag formula using VBA

[Wamhoi]

Hi,

How would you use cell reference for the following VBA code?

Cells(10, 13).Select
Selection.AutoFill Destination:=Range("M3:T3"), Type:=xlFillDefault

Instead of "M3:T3" I'd rather use a cell reference or some kind of offsetting to drag a formula

 

[Michael M]

try

Range(cells(3,13),cells(3,20))

 

[AlphaFrog]

Cells(10, 13).AutoFill Destination:=Cells(10, 13).Resize(,8), Type:=xlFillDefault

This will autofill M10:T10

 

[Wamhoi]

Both work thanks!!