hello guys i need some help
i need macro whitish take my formula in cell and bring down to all rows
Something like this but not for range but for last row and not for active worksheet but for specifics sheet "Actona" "BXS" "NEPATVIRTINTI" "MOEMAX"Range("R3").Select Selection.AutoFill Destination:=Range("R3:R22"), Type:=xlFillDefault Range("R3:R22").Select Range("V3").Select Selection.AutoFill Destination:=Range("V3:V22"), Type:=xlFillDefault Range("V3:V22").Select Range("AD3:AF3").Select Selection.AutoFill Destination:=Range("AD3:AF22"), Type:=xlFillDefault Range("AD3:AF22").Select End Sub
i add sample all my formulas in hidden Row 3 i mark cells be yellow color which have formulas.
Bookmarks