AutoFill Using a macro

[Richard]

I have a macro that will take the formula that that I have in cell B2 and I
need it to be able to do an autofill for me, any suggestions on how to
accomplish this? So far I have the following code:

Selection.AutoFill Destination:=Range("G2:G50")
Range("G2:G50").Select
Range("G2").Select

I don't want it to always autofill to G50 if I can help it, any suggestions?

Richard

 

[Harald Staff]

How would the code know how far down you want to fill ? You want to tell it,
or is there a pattern somewhere ?

Best wishes Harald

Selection.AutoFill Destination:=Range("G2:G50")

I don't want it to always autofill to G50 if I can help it, any

suggestions?

 

[Don Guillett]

Wasn't this answered in another thread very recently?


'br = Cells(Rows.Count, "b").End(xlUp).Row
br=33 'or whatever number you like. See Dave's post
Cells(1, "b").autofill Destination:=Range(Cells(1, "b"), Cells(br, "b"))