Applying methods to Offset

[oakwood_001]

Hi All,

Hope you had a good weekend. Have a question about a method of 'Offset'

I have a formula that I want to autofill by a certain amount (intRowCount which is an integer) but I'm not sure what method to apply to Offset in order to make it work:

Selection.AutoFill Destination:= Range(Range("AI4"), Range("AI4").Offset(intRowCount, 0)), Type:=xlFillDefault

Or am I doing this the wrong way round and should I be applying AutoFill Destination to the Range with the Offset in ()?

Thanks All.

 

[Richard Schollar]

Hi

Selection.AutoFill Destination:= Range("AI4").Resize(intRowCount), Type:=xlFillDefault

 

[oakwood_001]

Sorry my mistake - it does work but I wasn't specifying my variable correctly *embarrassed*

 

[oakwood_001]

Thanks Richard - much easier way to do it than mine