IF FUNCTION

[Guest]

CAN I INSERT ROW OR COLUMN WHILE USING IF FUNTION FORMULA.

THANK YOU !!

 

[Dave R.]

This cannot be done with a formula but could be done with VBA.

 

[Gord Dibben]

No

Worksheet Function Formulas can only return values to the cell in which they
reside.

To insert rows and/or columns you would need your "If" statement in a macro.

Sub Insert_Row()
If ActiveSheet.Range("A1").Value = "chan" Then
Range("A1").Offset(3, 0).EntireRow.Insert
End If
End Sub

Gord Dibben Excel MVP