A
Ardy
I have generated a code with help of macro's that will select a range
and then Auto fills it to a given range. It all works fine with one
exception. What I really like to do is stop copying the formula if
there is no values in Column A, in other word do copy until cell in
Column A is Null, Starting from A3.
Range("C2:BL2").Select
Selection.AutoFill Destination:=Range("C2:BL43"),
Type:=xlFillDefault
Range("C2:BL43").Select
A B C D E F Etc ----------->
1 NAME Formula Formula Formula
2 Name
Ardy
and then Auto fills it to a given range. It all works fine with one
exception. What I really like to do is stop copying the formula if
there is no values in Column A, in other word do copy until cell in
Column A is Null, Starting from A3.
Range("C2:BL2").Select
Selection.AutoFill Destination:=Range("C2:BL43"),
Type:=xlFillDefault
Range("C2:BL43").Select
A B C D E F Etc ----------->
1 NAME Formula Formula Formula
2 Name
Ardy