IF FUNCTION
 

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

THANK YOU !!

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


"Chandrashekhar" wrote in message
...
CAN I INSERT ROW OR COLUMN WHILE USING IF FUNTION FORMULA.

THANK YOU !!

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

On Wed, 24 Nov 2004 21:11:02 -0800, "Chandrashekhar"
wrote:

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

THANK YOU !!