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
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
>
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
>
>
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
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
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
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)
But where u want to paste those formula means which range all sheets have
the same 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$$
Rajesh Ji,
In my workbook, formulas are in range b. This macro code is working on
other ranges also. Thanks to you very much.
Regards,
Mukesh Kumar
On Fri, Sep 27, 2013 at 1:17 PM, Ravinder wrote:
> But where u want to paste those formula means which range all sheets have
> the same format..*
This was the initial request from you
" 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. "
i cant see anywhere you need it for column B only :)
Regards
Rajan.
10 matches
Mail list logo