+ Reply to Thread
Results 1 to 4 of 4

VB Code to add formula in cell

  1. #1
    Forum Contributor
    Join Date
    01-31-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    193

    VB Code to add formula in cell

    Hello:

    Please refer to attached file.
    I need VB Code to put formula in the cell as show in cell G2 and copy down.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: VB Code to add formula in cell

    Something like:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to add formula in cell

    Hello TMS:

    Thanks a lot

    R

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: VB Code to add formula in cell

    You're welcome. Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vba code when cell in range returns a certain value, enter formula in nearby cell
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2018, 08:16 AM
  2. [SOLVED] IF formula or vba code to not have numbers in cell added in total cell
    By Scrapnforfun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-26-2017, 08:38 PM
  3. [SOLVED] Convert formula to VBA code without viewing the formula in Cell
    By KumarPK in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2016, 11:02 AM
  4. need a formula or vba code to change cell value form another cell
    By yusufugan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2013, 10:15 AM
  5. Replies: 3
    Last Post: 06-19-2013, 03:40 AM
  6. [SOLVED] VB Code to add Formula in Cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2013, 10:54 AM
  7. [SOLVED] Code to delete cell contents IF the result of a formula in the cell = 0
    By jayjaynz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2013, 03:58 AM

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