+ Reply to Thread
Results 1 to 3 of 3

VBA code for Formula

  1. 05-08-2020, 11:05 PM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,725

    VBA code for Formula

    I have the following formula in Col F


    Please Login or Register  to view this content.

    I have tried to write code for the formula in VBA to include the range from sheet "Exclude Items" from A1 up to the last row containing data on Col A on this sheet


    It would be appreciated if someone could kindly amend my code


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-08-2020, 11:23 PM #2
    huuthang_bd
    huuthang_bd is offline
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: VBA code for Formula

    Try
    Please Login or Register  to view this content.
    ❖ Please mark your thread is SOLVED if there has been offered a solution that works fine for you.

    ❖ If you like solutions provided by anyone, feel free to add reputation by clicking on ✶ Add Reputation bottom left of their posts.
    Reply With QuoteRegister To Reply
  3. 05-08-2020, 11:59 PM #3
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,725

    Re: VBA code for Formula

    Thanks, Code works perfectly
    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. writing vba code to fill in column of sheet, formula works vba code will not
    By pdx2245 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2019, 05:15 PM
  2. [SOLVED] Code last row of formula in VBA code to correspond with last row of data
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2015, 12:06 AM
  3. sir how to vlookup formula two line break in excel. sir my code is, this code is working a
    By mahesh_1981 in forum Excel General
    Replies: 1
    Last Post: 11-13-2013, 10:28 AM
  4. Advice and help with a copy past code or filldown formula code
    By KELLIS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2013, 02:07 PM
  5. Help: formula or VB code to implement voting system code
    By cdsc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2013, 01:23 AM
  6. [SOLVED] Array Formula vs vBa code - How To Modify My Messy Code To One Of Those
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2012, 12:04 AM
  7. Sumproduct formula:Empl Code Payroll Code Amount
    By bluemeg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2009, 02:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1