Consulting

Results 1 to 2 of 2

Thread: copy Formulas instead of Text values

  1. #1
    VBAX Regular
    Joined
    Nov 2012
    Posts
    24
    Location

    Question copy Formulas instead of Text values

    Dear All,

    I would request to kindly look into this issue and revert at your earliest convenience.

    INPUTS(Sheet name)

    Problem#1

    Please refer Column " BN" in Inputs sheet whereas formulas are updated as Text values , below is the code that i have used :

    Sheets("Inputs").Select
    Range("A1").Select 
    Selection.End(xlToRight).Select 
    Range("BN1").Select 
    ActiveCell.FormulaR1C1 = "Total" 
    Range("BN2").Select 
     
     
    Range("BN2").Formula = "=Sum(AN2+AK2+AL2+AB2+AD2+z2)" 
     
     
    Range("BN2").Select 
    Selection.Copy 
    Range("BM1").Select 
    Selection.End(xlDown).Offset(-1, 1).Select 
     
    Range(Selection, Selection.End(xlUp)).Offset(1, 0).Select 
     
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ 
    SkipBlanks:=False, Transpose:=False 
    Application.CutCopyMode = False


  2. #2
    VBAX Regular
    Joined
    Nov 2012
    Posts
    24
    Location
    Hi Team,

    Can you please help me on this request ?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •