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 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
>
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
To: MS EXCEL AND VBA MACROS
Sent: Monday, June 15, 2009 5:35:29 PM
Subject: $$Exce
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
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
> F
