Results 1 to 8 of 8

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

Threaded View

  1. #5
    Registered User
    Join Date
    10-30-2023
    Location
    Honduras
    MS-Off Ver
    2021
    Posts
    27

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

    Hi Greg, with your explanation about the sheets I made it work, but now I face a new problem: My file contains 6 worksheets and I would like to know if you could modify your code so this would work with all six pages, since your code only defines 1 SHEET__WITH_FORMATTING. I'm sending you my file (hope I did it right). Thank you very much!
    Attached Files Attached Files

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. 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