Results 1 to 2 of 2

Thread: Copying formula to proper column in excel

  1. #1

    Copying formula to proper column in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,
    I have already wrote the VBA code which is adding the a new column to the right of the last column.What I want to do that is to copy the formula of last column and the range should change with suitable column.
    For example I am using that formula on the last column.
    =$A$186+SUMPRODUCT($B$14:$B$160;C14:C160)+SUMIF($C14:C160;"<1")
    And I need to change "C" parts of the code.
    Thanks!!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Hello,

    It has been reported that you have crossposted your question in other forum(s) and it seems to have been resolved. Can you please supply links to those other threads here.

    Please read here to understand why we ask: http://www.excelguru.ca/content.php?184


Posting Permissions

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