+ Reply to Thread
Results 1 to 4 of 4

VB Code to copy range of formulas

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

    VB Code to copy range of formulas

    Hello;

    Please refer to attached file and go to sheet "OT".
    I need a VB Code to do the following.
    If Name exit in cell E1,I1,M1,Q1,U1,Y1 and so on..(every 4th column) then check to see if formula in corresping
    row (E3,I3,M3,Q3 and so on.
    If NO Formula then copy formula from Cell Range(E3:G26) at corresponding cell.
    In this case at Q3,U3,Y3 until AG3

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VB Code to copy range of formulas

    Hi Riz

    Try this...
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

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

    Re: VB Code to copy range of formulas

    Hi Jaslake:

    Thanks a lot it works great.

    Riz

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VB Code to copy range of formulas

    You're welcome...glad I could help. Thanks for the Rep.

+ 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. Copy Range of Formulas to a Variable Range of Cells
    By xace in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-07-2015, 10:28 PM
  2. [SOLVED] Code to add new row and copy formulas only (not values)
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-02-2014, 03:36 PM
  3. [SOLVED] How to copy a range (including any formulas in the range) into an array?
    By jimmalk in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-28-2012, 01:51 AM
  4. 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
  5. How do I copy formulas but using the same range each time I copy
    By Laffin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-22-2006, 11:17 AM
  6. copy formulas from a contiguous range to a safe place and copy them back later
    By Lucas Budlong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2006, 04:35 PM
  7. [SOLVED] Copy formulas via Code
    By Cordobes in forum Excel General
    Replies: 1
    Last Post: 12-11-2005, 10:55 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