Results 1 to 10 of 10

VBA to Clear Cells that Contain #N/A and also VBA to re populate formula in #N/A cells

Threaded View

  1. 07-02-2016, 04:58 PM #1
    Gerry Pasveer
    Gerry Pasveer is offline
    Registered User
    Join Date
    07-02-2016
    Location
    Vernon BC
    MS-Off Ver
    2013
    Posts
    17

    VBA to Clear Cells that Contain #N/A and also VBA to re populate formula in #N/A cells

    So Im trying to Plot some lines with gaps in 2013 excel with 3 rows containing thousands of cells

    In order to plot the gaps I have to remove the formula in the #N/A cells

    But if possible I still need to re populate the formula back to the cells ?

    Work Sheet name is " Curve Data "


    The attached file has a sample of data I would like to plot ( work restrictions on formulas )

    Thanks in Advance, Gerry
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Trying to Clear the same part of a formula in multiple cells...w/ No luck
    By JF1998 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-15-2016, 03:37 PM
  2. Clear cells, Copy formula and paste, populate formulas by combining macros
    By Sekars in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2016, 02:14 AM
  3. [SOLVED] Creating a formula to populate data in particular cells based on conditions in other cells
    By jamietofs in forum Excel General
    Replies: 5
    Last Post: 10-15-2012, 06:33 PM
  4. Clear contents of cells that do not contain specific text, sort cells that do
    By feckless.lout in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2010, 01:41 AM
  5. week end formula & clear cells button
    By bassett in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-26-2009, 11:56 PM
  6. Look Through Sheet & Clear Cells which do not have formula
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2009, 12:14 AM
  7. Formula to clear cells based on another cell value
    By mrdata in forum Excel General
    Replies: 2
    Last Post: 02-22-2008, 05:58 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