+ Reply to Thread
Results 1 to 3 of 3

How can I use SpecialCells to include only Visible cells with Values?

  1. #1
    Registered User
    Join Date
    09-14-2021
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    How can I use SpecialCells to include only Visible cells with Values?

    I'm trying to fix my macro so the table portion of my email body only includes Visible cells with Values but as it is currently written, it ignores the xlCellTypeConstants enumeration. Is there a way to include both xlCellTypeVisible and xlCellTypeConstants? I've attached my current spreadsheet and the code can be run by clicking the Command Button at the top.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How can I use SpecialCells to include only Visible cells with Values?

    Which specific cells should it be ignoring?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-14-2021
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Re: How can I use SpecialCells to include only Visible cells with Values?

    Quote Originally Posted by Richard Buttrey View Post
    Which specific cells should it be ignoring?
    I'm wanting it to ignore all columns that are hidden and any row that is blank. Ideally, my table in this example would just include ranges A3:H18 and J3:J18.

+ 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. BUG in my SpecialCells visible formula
    By zextrot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2017, 05:33 PM
  2. Using SpecialCells to set a range of cells that are BOTH visible and non-blank?
    By walruseggman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2015, 12:22 PM
  3. Creating array of specialcells(visible) returns only first x cells
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-27-2013, 11:04 AM
  4. [SOLVED] SpecialCells(xlCellTypeVisible) Not Returning Visible Cells Resulting from AutoFilter
    By Filibuster in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2012, 05:48 AM
  5. [SOLVED] Copy/Pasting Values from visible cells (using autofilter) to visible cells
    By evakotsi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 07:49 AM
  6. Copy Visible cells and paste values only to visible target cells
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2010, 04:09 AM
  7. How do I include only visible cells in a range?
    By Frequent User in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-28-2005, 12:35 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1