Re: $$Excel-Macros$$ paste special particular formula

2013-09-27 Thread rajan verma
gt;> *Sent:* Thursday, September 26, 2013 3:10 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ paste special particular formula >> >> ** ** >> >> Hi experts, >> >> I need a macro code to paste special a particular for

Re: $$Excel-Macros$$ paste special particular formula

2013-09-27 Thread Mukesh Kumar
format.. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar > *Sent:* Thursday, September 26, 2013 3:10 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ paste special particula

RE: $$Excel-Macros$$ paste special particular formula

2013-09-27 Thread Ravinder
$$ paste special particular formula Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Thanks a lot Rajan Ji for your help. This code is working fine. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 12:03 PM, rajan verma wrote: > > So problem was the reference in formulas , if any formula have reference > like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here)

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
So problem was the reference in formulas , if any formula have reference like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here) it will always assume that reference is from activesheet until we provide full reference like Sheet1!A1:A5, but it is complex to write that code , so

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
use this one. Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox("Enter formula name to replace with values") lngCou

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
Try this one Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox("Enter formula name to replace with values") lngCoun

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Rajan ji , this macro code is limited to one sheet only. I want the macro that works upon all sheets at once. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 3:39 PM, rajan verma wrote: > HI Mukesh > > i have seen this query many time on this group and another forums, please > try this macro > >

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Thanks a lot Sir for the help. On Thu, Sep 26, 2013 at 3:39 PM, rajan verma wrote: > HI Mukesh > > i have seen this query many time on this group and another forums, please > try this macro > > > Sub PasteFormula() > > Dim rngRange As Range > Dim VarArr > Dim strFormula As String >

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
HI Mukesh i have seen this query many time on this group and another forums, please try this macro Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Set rngRange = Activ

$$Excel-Macros$$ paste special particular formula

2013-09-26 Thread Mukesh Kumar
Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?