The Formula Array work with Row() Ok, and Has error with Column() ! please help
Get Err Mesage
unable to set the Array Formula property of the Range Class
Code:
Sub Rw()
Range("A16:L40").[B][COLOR=#006400]FormulaArray[/COLOR] [/B]= "=IFERROR(MID(A1,FIND(""|"",SUBSTITUTE("",""&A1&"","","","",""|"",(ROW()-ROW(B$3)+1))),FIND("","",A1&"","",FIND(""|"",SUBSTITUTE("",""&A1&"","","","",""|"",(ROW()-ROW(B$3)+1))))-FIND(""|"",SUBSTITUTE("",""&A1&"","","","",""|"",(ROW()-ROW(B$3)+1)))),"""")"
End Sub
unable to set the Array Formula property of the Range Class
Code:
Sub Col()
Range("A2:z118").Clear
Range("A16:L40").[COLOR=#ff0000]FormulaArray[/COLOR] = "=MID($A1,FIND(""|"",SUBSTITUTE("",""&$A1&"","","","",""|"",(COLUMN()-COLUMN($B1)+1))),FIND("","",$A1&"","",FIND(""|"",SUBSTITUTE("",""&$A1&"","","","",""|"",(COLUMN()-COLUMN($B1)+1))))-FIND(""|"",SUBSTITUTE("",""&$A1&"","","","",""|"",(COLUMN()-COLUMN($B1)+1))))"
End Sub