+ Reply to Thread
Results 1 to 3 of 3

remove color after last non-empty row

  1. 11-27-2020, 03:32 AM #1
    john_cash
    john_cash is offline
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    487

    remove color after last non-empty row

    Hi
    how to delete the color after the last non-blank row after editing the sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-27-2020, 04:25 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: remove color after last non-empty row

    Please try

    Please Login or Register  to view this content.
    Alternative code to check CurrentRegion instead of column A
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Bo_Ry; 11-27-2020 at 05:20 AM. Reason: Add alternative code
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 11-27-2020, 04:58 AM #3
    john_cash
    john_cash is offline
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    487

    Re: remove color after last non-empty row

    Thanks Bo_Ry
    Work well
    A greeting
    john
    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. If a2 is not empty, color empty cells in b2:af2
    By turkanet in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-26-2017, 04:47 PM
  2. Remove duplicates from several colums and concatenate and remove empty colums
    By Nemona in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-30-2015, 06:42 PM
  3. Conditional Formatting - Color unprotected cells, remove color once text entered
    By jrc905 in forum Excel General
    Replies: 3
    Last Post: 05-30-2014, 10:24 AM
  4. [SOLVED] How to remove empty space, unable to make pvot, because pvot calculate empty space
    By vengatvj in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 10-29-2013, 12:43 PM
  5. Color fill a cell and then remove the color when a date is added.
    By texas tornado in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2012, 02:14 AM
  6. How do I remove the empty Rows?
    By Lewis Koh in forum Excel General
    Replies: 4
    Last Post: 04-18-2010, 08:48 PM
  7. [SOLVED] How to remove the empty row
    By Alan Tang in forum Excel General
    Replies: 5
    Last Post: 02-15-2006, 08:20 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