AutoFill Range Syntax with Variable?

[JazzSP8]

Hey All

Can't seem to work out the correct method for this.

I want to select and then Autofill a set of Formulas but no matter what I try I keep getting an Error

This is what I started with that I thought would work;

Range(Cells(j, "E"), Cells(j, "G")).Select
Selection.AutoFill Destination:=Range("E" & OrderLastRow & ":G" & OrderLastRow)

I've used the variable that way before when filling in a single column but it doesn't seem to like to do it when there is more than one

Can someone point me in the right direction?

Thanks

 

[Joe4]

Try this:

Range(Cells(j, "E"), Cells(j, "G")).AutoFill Destination:=Range("E" & [COLOR=#ff0000][B]j [/B][/COLOR]& ":G" & OrderLastRow)

Note the difference is the part in red (the other thing is I just combined your two rows together - you do not need to select ranges to work with them in VBA, the VBA Recorder is just very literal).

 

[decadence]

Is this all of your code? Is it only Column E and G that you want to populate or E to G?

 

[JazzSP8]

Note the difference is the part in red (the other thing is I just combined your two rows together - you do not need to select ranges to work with them in VBA, the VBA Recorder is just very literal).

Ha! - Yes! - That would work better LOL - Thursday Brain is what I'm blaming that one on!

Thanks for the tip on combing the lines as well!

Is this all of your code? Is it only Column E and G that you want to populate or E to G?

It is E to G - But Joe4 has pointed out what I was doing wrong now, thanks for the interest though

 

[Joe4]

You are welcome!

Yes, the first row in your Autofill always has to be the row you are copying from.

Thanks for the tip on combing the lines as well!

Yes, most anytime you have one row end in "Select" or "Activate", and the next line begins with "Selection" or "ActiveCell", you can combine those two rows together.
Not only does it shorten your code, it also speeds it up (as selecting cells in VBA code slows it down).