+ Reply to Thread
Results 1 to 5 of 5

showing value in a cell

  1. 08-18-2020, 06:25 PM #1
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    showing value in a cell

    Hello

    I have this code in A2. My issue is that if A1 is blank with no entry on it, there a #VALUE showing. Can you please recode to not showing the #VALUE? I want A2, A3, A4, etc. to be lank if there is no entry in A1.

    Thank you all in advance!


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-18-2020, 06:37 PM #2
    maniacb
    maniacb is offline
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: showing value in a cell 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 08-18-2020, 06:48 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: showing value in a cell

    Or just
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 08-18-2020, 07:29 PM #4
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: showing value in a cell

    Thank you.
    Reply With QuoteRegister To Reply
  5. 08-18-2020, 10:15 PM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: showing value in a cell

    You're welcome. Thanks for the rep.
    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. Showing a blank cell when no data is used. Or showing a blank cell formula unused
    By ntraviglia in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 10-25-2016, 03:34 PM
  2. Cell with Formula Not Showing Date - Only Showing Serial Number
    By jbb89777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2016, 04:33 AM
  3. [SOLVED] Showing two values stacked but also showing their individual lines all on the same graph
    By Robbie8 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-22-2016, 05:25 PM
  4. 2 issues: Password showing and Sheets showing even though hidden in VBA
    By jlheath01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2014, 10:24 PM
  5. Popup message showing adjacent cell value when user enters value in cell
    By kevinkusman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2013, 12:21 PM
  6. Macro error, Formula cell showing a green triangle in top cell
    By sherry_1991 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2013, 02:09 PM
  7. showing cell reference of highlighted cell in another fixed cell on the spreadsheet
    By tx12345 in forum Excel General
    Replies: 1
    Last Post: 09-03-2006, 05:38 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