+ Reply to Thread
Results 1 to 5 of 5

VB Code to create formulas

  1. 07-26-2017, 12:09 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to create formulas

    Hello:

    I need vb code to assign formulas ot cell F2:F32 as below

    F2 = =Dly_Sum!AA3
    F3 = =Dly_Sum!AA4
    F4 = =Dly_Sum!AA5
    F5 = =Dly_Sum!AA6

    and so on...

    Please let me know if you have any questions.
    Thanks.

    Riz
    Reply With QuoteRegister To Reply
  2. 07-26-2017, 12:15 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: VB Code to create formulas 

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 07-26-2017, 12:15 PM #3
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: VB Code to create formulas

    Something like this I'd say:

    Please Login or Register  to view this content.
    Or what shg said... much better than mine
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  4. 07-26-2017, 12:20 PM #4
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to create formulas

    Hello shg:

    Your code works, thanks a lot

    Riz
    Reply With QuoteRegister To Reply
  5. 07-26-2017, 12:23 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: VB Code to create formulas

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create sum formulas with code
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2015, 01:34 PM
  2. VBA code to create new year and copy down formulas
    By KTW6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2014, 07:08 AM
  3. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  4. [SOLVED] Help me fix attached code (create Outlook email then create calendar item)
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2013, 08:15 PM
  5. VBA code to create formulas referencing cells in another workbook
    By new.vbacoder in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2010, 05:11 PM
  6. code to add formulas to a range with previous formulas appearing inside the new one
    By Excel-o-ratoR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2010, 06:02 AM
  7. How to create a form to insert a hyerlink.VBA code to create a for
    By karthi in forum Excel General
    Replies: 0
    Last Post: 07-05-2006, 06:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1