Excel VBA Macro - Convert Formulas to Values in excel | Advance Excel

preview_player
Показать описание
Excel VBA macro
Advance Excel course
Convert Formulas to Values in Excel
Advance Excel vba
Vba tutorial
Рекомендации по теме
Комментарии
Автор

s there a way I can do this for 50 columns? .Range("N18").Formula = " =(IF(AND(, F5="", G5="", H5=""), "", I4+F5-G5-H5))" can pls help me Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("A1") <> "" Then
Range("A1").Select
Selection.AutoFill _
Destination:=Range("A1:A5"), Type:=xlFillDefault
'.Range("K5").Formula = "=IF(AND(F5="", G5="", H5=""), "", (I4+F5-G5-H5))"

End If
End Su

karmusinghsiddhu