+ Reply to Thread
Results 1 to 3 of 3

Posting countif formula to cell using VBA

  1. 11-07-2018, 01:08 PM #1
    Neuk
    Neuk is offline
    Forum Contributor
    Join Date
    11-21-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    150

    Posting countif formula to cell using VBA

    The below line works but doesn't post the formula in the cell: 

    Please Login or Register  to view this content.
    I've tried several variations of the below formula and I just can't get it to work...any ideas?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-07-2018, 01:25 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Posting countif formula to cell using VBA

    I'm assuming z is a Range variable.

    Please Login or Register  to view this content.
    You may not want the quotes around the "202" in the formula. If yes, then this...
    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 11-07-2018 at 01:28 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 11-07-2018, 02:21 PM #3
    Neuk
    Neuk is offline
    Forum Contributor
    Join Date
    11-21-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    150

    Re: Posting countif formula to cell using VBA

    Thanks Alpha Frog, that did the trick!
    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. [SOLVED] Cell reference in a countif formula
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2018, 07:11 PM
  2. [SOLVED] Formula Help, Countif (every other cell, X as 1)
    By EBFH in forum Excel General
    Replies: 7
    Last Post: 07-26-2016, 04:17 PM
  3. [SOLVED] Enter formula result from one cell into a COUNTIF formula in another cell. Help please!
    By gregrach in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 11:23 AM
  4. [SOLVED] countif formula changes cell values and cell reference is unchanged
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2014, 11:37 AM
  5. [SOLVED] Countif formula in one cell
    By sandiptemkar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2013, 11:38 AM
  6. COUNTIF formula with reference to cell above
    By pri31 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2013, 08:07 AM
  7. [SOLVED] CountIf previous cell formula
    By Mark D Flanagan in forum Excel General
    Replies: 5
    Last Post: 07-15-2012, 10:43 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