[mailto:
excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
*Sent:* Saturday, January 18, 2014 4:48 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Replace formulas with values
Thanks Ravi for your help. This sheet fulfills my motive to some extent
...@gmail.comwrote:
Hi,
PFA…
*Warm Regards,*
*Ravi Kumar.*
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar
*Sent:* Saturday, January 18, 2014 12:25 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Replace formulas
Hi Experts,
I need your help. My requirement is that I want to replace cell addresses
with their respective values (*paste special not required as it will
replace whole formula with values)*, e.g. let's say that the formula of
cell C2 is =A1+B1, where A1 = 10 and B1 = 20, then I would like to
Sub test()
Dim i As Long
For i = 2 To Range(a65356).End(xlUp).Row
Range(c i).ClearContents
Range(c i).Formula = = Range(a i).Value * Range(b
i).Value
Next
End Sub
On Sat, Jan 18, 2014 at 12:24 PM, Mukesh Kumar mukeshka...@gmail.comwrote:
Hi Experts,
I need your help. My
Ashish ji, this code is working on column C only not on column E which also
contains formula. As I have said earlier that user form is required which
asks for range of cells first where to apply macro?
Any help in this regards will be helpful to me.
On Sat, Jan 18, 2014 at 12:50 PM, ashish koul