Results 1 to 6 of 6

code to assign formula without $ sign.

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    Doha
    MS-Off Ver
    Excel 2010
    Posts
    8

    code to assign formula without $ sign.

    Good Afternoon,

    I novice in Excel macro and developing a routine to paste multiplication formula and page sum formula.
    The formula is pasted but, i want without $ sign ( like =$c$2 *$e$2). but i need without $ sign.

    The below is my routine

    For Rw = srow To lastrow
    
    If ActiveSheet.Cells(Rw, Qtycolumn).Value > 0.001 Then
    
    If ActiveSheet.Cells(Rw, Ratecolumn).Value = "" Then
    ActiveSheet.Cells(Rw, Amountcolumn).Value = "Included"
    
    'Else: Cells(Rw, Amountcolumn).FormulaR1C1 = "=RC[-3]*RC[-1]"
    
    Else: Cells(Rw, Amountcolumn).Formula = "=" & Cells(Rw, Qtycolumn).Address & "*" & Cells(Rw, Ratecolumn).Address
    
    End If

    Another,

    Dim sumstart, sumfinish As Variant
    
    sumstart = Cells(QRaddress(i - 1) + 2, 6).Address
    sumfinish = Cells(QRaddress(i) - 1, 6).Address
    
    Cells(QRaddress(i), 6).Formula = "=Sum(" & sumstart & ":" & sumfinish & ")"

    Thanks in advance
    Last edited by vaasto2003; 08-21-2017 at 08:36 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Electronic Sign-off in Excel - Code or 3rd party or Add-in
    By wrs007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2016, 12:42 PM
  2. VB Code to assign Macro Button to certain Code
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2016, 05:36 PM
  3. [SOLVED] Formula or vba to assign a priceing band to UK postal code.
    By A440 in forum Excel General
    Replies: 15
    Last Post: 11-24-2015, 02:25 PM
  4. Add Percentage Sign to Code
    By Azurulean in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-15-2014, 01:53 PM
  5. [SOLVED] code to insert dash sign
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-06-2013, 11:01 PM
  6. Convert sign ( - ) to value hex code
    By sunwordelite in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-02-2009, 02:04 PM
  7. Code Sign PW Protected Project?
    By Walt Weber in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2005, 10:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1