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
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:
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
Hi,
Include this line in the code:
A = Range(D21).Value * Range(D20).Value
The variable 'A' will store the number you're looking for.
Regards - Dave.
Date: Mon, 15 Jun 2009 14:35:29 -0700
Subject: $$Excel-Macros$$ getting the value from a cell that has a forumla in
it
From: