Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF FUNCTION
CAN I INSERT ROW OR COLUMN WHILE USING IF FUNTION FORMULA.
THANK YOU !! |
#2
|
|||
|
|||
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 !! |
#3
|
|||
|
|||
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 !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
need to save values from a function before it changes | Excel Worksheet Functions |