+ Reply to Thread
Results 1 to 2 of 2

Clear columns with hidden cells?

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Clear columns with hidden cells?

    Is there a version of .Clear that will clear both visible and hidden cells (using an Advanced filter) in a range? I’ve found ways to clear the hidden cells, but not both in one command. I’d prefer not to unfilter the range first. I can copy a blank range from another part of the worksheet and paste it over the filtered column which works, but just seems like there should be a clear version that would do it. Anyone know? Thanks.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Clear columns with hidden cells?


    Range = Empty

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count cells while ignoring hidden columns
    By footes17 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2016, 05:58 PM
  2. macro to compare and clear cells in two columns
    By ncarrocino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2016, 01:13 PM
  3. [SOLVED] Clear contents in specific cell and the cells in the next 2 columns to the right
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2014, 01:25 AM
  4. Replies: 0
    Last Post: 01-15-2014, 05:17 PM
  5. clear selection in cells across multiple columns
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2013, 12:15 PM
  6. Replies: 0
    Last Post: 09-13-2012, 11:10 AM
  7. [SOLVED] PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns
    By Rob the Winer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2005, 04:17 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