+ Reply to Thread
Results 1 to 6 of 6

implement a furmula to range of cells using VBA

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    22

    implement a furmula to range of cells using VBA

    Hi Friends

    I am using a formula in a cell its

    Please Login or Register  to view this content.
    every time i am copying it to the next cell

    can i use VBA to do it in range like (F2:F1000)

    I have attached a sample for better understanding
    u can notice the Formula in F2 - G2 .... etc

    sample.xlsx

    Thankd in advance

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: implement a furmula to range of cells using VBA

    Pl see the attached file.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-24-2013
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: implement a furmula to range of cells using VBA

    Hmmm

    After trying some of mu luck I came up with this :

    Please Login or Register  to view this content.
    it works for me but here is a noob qustion
    when i save the file it didnt work
    do i need to run the macro then save? and this goes for every time i write a new macro ?? first to run it manualy then save the file?

    Thx

  4. #4
    Registered User
    Join Date
    10-24-2013
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: implement a furmula to range of cells using VBA

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see the attached file.

    Will sir you have changed the formula while i was asking how to apply my formula to range using VBA

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: implement a furmula to range of cells using VBA

    The formula can be simply dragged.
    Pl see the attached file with Macro.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 11-05-2013 at 01:07 AM.

  6. #6
    Registered User
    Join Date
    10-24-2013
    Location
    saudi arabia
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: implement a furmula to range of cells using VBA

    I have manage to write the VBA

    Kvsriniva THx alot for ur help

+ 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. putting cell text into another cells furmula
    By ratdogexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2013, 04:16 AM
  2. Replies: 1
    Last Post: 07-17-2013, 03:59 PM
  3. SUMIFS furmula
    By atlant15 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-17-2012, 03:38 AM
  4. [SOLVED] Implement a Formula into a Range with VBA
    By Seraph122 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2012, 03:39 PM

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