If the formula is in cell... E2 then: Range("E2").value Range("E2").formula
will give you the value and formula... I'll let you figure out which is which ;-) Paul ________________________________ From: RCGUA <stv.nels...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Monday, June 15, 2009 5:35:29 PM Subject: $$Excel-Macros$$ getting the value from a cell that has a forumla in it I'm sorry if this is a really simple question or if the answer could be found in the archives, I could not find it. I have a workseet with a simple that has a simple forumula =D21*D20 in VBA, I need to get the value of that cell. Thanks for your help, I hope it is something very simple, sorry again if I missed something obvious. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---