Microsoft Office Forums - View Single Post - Use varilable in vba excel formula

Thread: Use varilable in vba excel formula

View Single Post

Old

03-13-2017, 10:46 AM

Cosmo

Cosmo is offline

Cosmo uses Windows Vista

Windows Vista Cosmo uses Office 2007

Cosmo uses Office 2007

Office 2007

Competent Performer

Join Date: Mar 2012

Posts: 240

Cosmo is on a distinguished road

Default

Cells(42, 6).Formula = "=IF(AND((LEFT(E150,(FIND(""-"",E" & CSTR(i) & ")-1)) = ""abc ""),(ISNUMBER(SEARCH(TRIM(RIGHT(E42,(LEN(E42)-FIND(""-"",E42)))), E150)))),TRUE,FALSE)"

Reply With Quote