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 <[email protected]>
To: MS EXCEL AND VBA MACROS <[email protected]>
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 [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
