I found this page for you.Probably this is what you want to do:www.ozgrid.com/News/excel-evaluate-formula-VBA.htm