+ Reply to Thread
Results 1 to 5 of 5

Clear data content in Particular worksheet

  1. 02-12-2023, 12:32 AM #1
    Han_05
    Han_05 is offline
    Registered User
    Join Date
    09-20-2022
    Location
    Canada
    MS-Off Ver
    Microsoft Office 2019
    Posts
    33

    Clear data content in Particular worksheet

    Hello,
    I am writing VBA to clear data of particular sheet where if the name is EAST RECORD then clear all the data.
    But i gives error message. Please do correct me where i went wrong ?

    Attached file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-12-2023, 12:47 AM #2
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Clear data content in Particular worksheet

    try this

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 02-12-2023, 01:01 AM #3
    Han_05
    Han_05 is offline
    Registered User
    Join Date
    09-20-2022
    Location
    Canada
    MS-Off Ver
    Microsoft Office 2019
    Posts
    33

    Re: Clear data content in Particular worksheet

    Thank you for giving response.
    What if i want to clear data with format cells in VBA ?
    Last edited by Han_05; 02-12-2023 at 01:27 AM.
    Reply With QuoteRegister To Reply
  4. 02-12-2023, 03:38 AM #4
    k1dr0ck
    k1dr0ck is offline
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021
    Posts
    979

    Re: Clear data content in Particular worksheet 

    Please Login or Register  to view this content.
    Last edited by k1dr0ck; 02-13-2023 at 03:58 AM. Reason: clearformat first
    Reply With QuoteRegister To Reply
  5. 02-13-2023, 10:49 PM #5
    Han_05
    Han_05 is offline
    Registered User
    Join Date
    09-20-2022
    Location
    Canada
    MS-Off Ver
    Microsoft Office 2019
    Posts
    33

    Re: Clear data content in Particular worksheet

    Thank you so much alansidman and kidr0ck. Appreciate it.
    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. 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. clear content of cell F22 in each worksheet when i open the workbook
    By nassark in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2018, 10:08 AM
  3. [SOLVED] Clear content referencing another cell's same content
    By papusale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2015, 05:21 AM
  4. Get specific data from other sheet and clear other content
    By zottiri in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-28-2015, 01:32 AM
  5. [SOLVED] Data Validation: How to clear/delete the content of the cell and not Data Validation List?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2015, 09:42 AM
  6. [SOLVED] Worksheet Change Event to Clear Content of the Cells value & Re-sort the data
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-13-2014, 03:09 PM
  7. [SOLVED] Clear Content of Select Cells in Newly Inserted Rows and Keep Data Validation
    By n_lindsey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2013, 02:22 AM

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