INsert Formula iin Macros

Hi All,


I have tried to insert the formula in VBA in Z4 Cell but it gives an error. Please advise what should i do. Formula works fine in normal excel but not in macros. Thank you in advance.


=IF(AND(U4="",Y4=""),"N/A in RMS Report",IF(Y4="","Office Location Missing in RMS",IF(IF(Y4="United States-New York-30 Rock-NYR","NY-30 Rock",IF(Y4="United States-Arlington, VA-Rosslyn-ROS","Arlington - Rosslyn",IF(Y4="United States-Arlington-1101 Wilson-ARN","Arlington - Wilson",IF(Y4="United Sstin-Briarwick-AUN","Austin-Briarwick",IF(Y4="United States-Costa Mesa-ORN","Orange Cnty-Costa",IF(Y4="United States-New York-1633 Broadway-NYB","NY-1633 Broadway",IF(Y4="United States-New York-140 Broadway-NYM","NY-140 Broadway",IF(Y4="United States-Alexandria-ALX","Alexandria - Duke",IF(Y4="United States-Jersechange Place-JCA","JerseyCty-Harbor",LEFT(SUBSTITUTE(Y4,"United States-",""),(FIND("-",SUBSTITUTE(Y4,"United States-",""))-1)))))))))))=(IF(L4="NY-30 Rock","NY-30 Rock",IF(L4="Arlington - Rosslyn","Arlington - Rosslyn",IF(L4="Arlington - Wilson","Arlington - Wilson",IF(L4="Austin-Briarwick","Austick",IF(L4="Orange Cnty-Costa","Orange Cnty-Costa",IF(L4="NY-1633 Broadway","NY-1633 Broadway",IF(L4="NY-140 Broadway","NY-140 Broadway",IF(L4="Alexandria - Duke","Alexandria - Duke",IF(L4="JerseyCty-Harbor","JerseyCty-Harbor",IFERROR(LEFT(L4,FIND("-",L4)-1),L4)))))))))))=TRUE,"","Office Mismatch")))