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
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
$$ 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
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)
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
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
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
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
>
>
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
>
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
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?
11 matches
Mail list logo