Thank You to all of you. I knew this was something simple but I just couldn't get it to work.
On Jun 16, 2:21 am, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi RCGUA, > > 'Assuming you have the formula in cell A1, use the following code. > Sub test() > Dim i As String > i = Range("a1").Value > MsgBox i > End Sub > 'Thanks, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On Tue, Jun 16, 2009 at 3:05 AM, RCGUA <stv.nels...@gmail.com> wrote: > > > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---