Results 1 to 18 of 18

Select and delete contents below diagonal of cell array

Threaded View

  1. #6
    Registered User
    Join Date
    10-26-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Select and delete contents below diagonal of cell array

    Further investigation reveals that every cell within the column and row "box" defined by the "n" sized diagonal is affected. That is the columns above the diagonal have their formulas converted to "0", and the ones below are cleared completely. The rows and columns outside this diagonal defined box +1 cell, maintain their formulas intact.
    Last edited by Jooles; 10-27-2013 at 07:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] macro to select 'all' and delete contents.
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2013, 09:08 AM
  2. Filling a diagonal matrix array with zeros
    By don.harvey in forum Excel General
    Replies: 2
    Last Post: 09-04-2009, 08:42 AM
  3. select the contents of a cell
    By Worldman1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2006, 07:55 AM
  4. [SOLVED] select cell at random and delete contents
    By JJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2005, 07:05 PM
  5. select only below diagonal from range
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2005, 03:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1