+ Reply to Thread
Results 1 to 3 of 3

how to distinguish between a value and a formula within a range

  1. 10-29-2017, 11:14 PM #1
    JimmyWilliams
    JimmyWilliams is offline
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Cool how to distinguish between a value and a formula within a range

    Hi guys,


    I have a macro uses the information from cells over a range.

    I need the macro to be able to distinguish between cells with values and other cells with formulas

    A1 = SUBTOTAL(9,A2:A10)
    A2 = $1,100
    A3 = A4/B4
    A4 = $900
    etc


    Something that would give me TRUE for A2 and A4 only.


    Thanks,
    Jimmy
    Reply With QuoteRegister To Reply
  2. 10-29-2017, 11:24 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: how to distinguish between a value and a formula within a range 

    Please Login or Register  to view this content.
    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. 10-29-2017, 11:53 PM #3
    JimmyWilliams
    JimmyWilliams is offline
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: how to distinguish between a value and a formula within a range

    Thanks AlphaFrog
    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] I need a formula that will distinguish blocks of data with sub headings as they are foud
    By john dalton in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2015, 10:40 AM
  2. Need help w/formula to distinguish taxable from non-taxable idems
    By todd774 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2014, 06:36 PM
  3. Distinguish 1 from 14 when using the filter
    By Ken64 in forum Excel General
    Replies: 8
    Last Post: 04-07-2014, 10:20 AM
  4. [SOLVED] Formula to calculate travelling and distinguish between weddings and corporates
    By blacktie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2013, 07:15 AM
  5. [SOLVED] This formula that I was given by my coordinator does not distinguish between,,,
    By laurabach in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-22-2013, 03:59 AM
  6. Formula to distinguish Month Year from prior Month Years
    By tmac in forum Excel General
    Replies: 4
    Last Post: 02-14-2010, 05:21 AM
  7. Date distinguish
    By hme in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2006, 07:43 AM

Tags for this Thread

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