+ Reply to Thread
Results 1 to 2 of 2

Adding A "Clear" Button to Worksheet to Clear a Range of Data

  1. #1
    Registered User
    Join Date
    01-01-2020
    Location
    London, England
    MS-Off Ver
    Office 365 E3 - version 1808
    Posts
    23

    Post Adding A "Clear" Button to Worksheet to Clear a Range of Data

    Hi all,

    Looking for some help with how to create a button on an excel file to clear a range of data (but not the whole worksheet) for easier clearance of data, rather than having to do it manually.

    I have attached the worksheet for reference and below is the ranges that i want to clear using the macro button:

    298R x 20C (A3:T3 and down 300 rows) and 298R x 4C (W3:Z3 and down 300 rows.

    This leaves formatting and column headers as well as some formula in the middle of the document without clearing.

    Any help will be greatly appreciated!

    Thanks

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,954

    Re: Adding A "Clear" Button to Worksheet to Clear a Range of Data

    All you really need is something like:

    Please Login or Register  to view this content.
    and assign that to a button/shape.
    Rory
    I drink, and I know things

+ 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. Clear an Unprotected Cell using a "Reset" Button on a Protected Spreadsheet
    By ah50 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2018, 12:53 AM
  2. [SOLVED] Timesheet - Adding "Submit" Button To Extract Data To Other Workbook, Save PDF & Clear
    By craigieuk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2015, 08:22 AM
  3. Replies: 1
    Last Post: 10-23-2013, 05:20 PM
  4. Replies: 3
    Last Post: 09-26-2012, 06:17 AM
  5. Create a clear/reset "button"?
    By splenguin in forum Excel General
    Replies: 10
    Last Post: 09-03-2009, 06:12 PM
  6. Assign button to clear all, "except"
    By darkwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2006, 06:45 PM
  7. [SOLVED] Adding a "CLEAR" button to the worksheet
    By Billy in forum Excel General
    Replies: 1
    Last Post: 01-08-2006, 02:09 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