Results 1 to 8 of 8

Clear format & everything from worksheet, except a range of cells' values (VBA) & back

Threaded View

RobotMan Clear format & everything... 11-27-2023, 09:26 PM
Greg M Re: Clear format & everything... 11-27-2023, 10:05 PM
RobotMan Re: Clear format & everything... 11-28-2023, 03:26 PM
Greg M Re: Clear format & everything... 11-28-2023, 04:43 PM
RobotMan Re: Clear format & everything... 11-28-2023, 08:58 PM
Greg M Re: Clear format & everything... 11-29-2023, 07:43 PM
RobotMan Re: Clear format & everything... 11-30-2023, 09:04 AM
Greg M Re: Clear format & everything... 11-30-2023, 09:35 AM
  1. #1
    Registered User
    Join Date
    10-30-2023
    Location
    Honduras
    MS-Off Ver
    2021
    Posts
    27

    Clear format & everything from worksheet, except a range of cells' values (VBA) & back

    Hi, I was wondering if there is a way to toggle clear/hide everything from a worksheet except from a range of cells I could specify and also bring everything back using VBA. The idea is that I want to print a, empty table and later on, print the values over that same paper once I'm ready to do so, then restore the original format once again (using a macro button to toggle it on/off). The range of cells I want to keep their values is C9:S33, everything else: format, conditional formating, objects, text, borders would be cleared/hid, and, with the same button with macro bring back everything once I need it back again.

    Hope I could explain myself.

    Thank you very much
    Screenshot_21.jpg
    Last edited by RobotMan; 11-27-2023 at 09:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding A "Clear" Button to Worksheet to Clear a Range of Data
    By theexcelnovice123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2021, 05:53 AM
  2. [SOLVED] VBA code for 2 buttons that can clear cells in a row then second button to bring data back
    By Hillster in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-08-2019, 09:14 PM
  3. [SOLVED] Changing color format in cells based on 3 range values in a different column cells.
    By konkonmike in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-08-2019, 08:11 AM
  4. [SOLVED] Macro to copy cells from a selected range and just paste values back to that same range
    By catscats11 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-18-2019, 02:59 PM
  5. [SOLVED] Help with code to creat Reset button to clear cells and copy back the original formula
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2015, 02:25 PM
  6. Copy Values from WorkSheet back to Another Workbook Replacing Values in Worksheet
    By bobwilson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2006, 04:50 PM
  7. [SOLVED] Automatically clear values from a range of selected cells
    By John Davies in forum Excel General
    Replies: 1
    Last Post: 06-28-2005, 12:05 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