> *From:* excel-macros@googlegroups.com [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 R
Thanks Ravi for your help. This sheet fulfills my motive to some extent.
But it will not work in following example :
*A1=40% ; B2=200 ; C1=100 ; D1=A1*B1+C1. D1 will return 180 and i want to
show th caclculation as "=40%*200+100*
I have searched many forum regarding this & following link has so
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
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 wrote:
> Hi Experts,
>
> I need your help. My requir
