+ Reply to Thread
Results 1 to 7 of 7

I need to code to clear contents the several fixed ranges of several sheets

  1. #1
    Registered User
    Join Date
    04-04-2016
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    21

    I need to code to clear contents the several fixed ranges of several sheets

    Hello everyone
    I need to code to clear contents the several fixed ranges of several sheets
    To be is deleted of all ranges in all the sheets Automatically
    at exactly eleven o'clock evening each day
    The beginning of the sheet No. 6 and ends on Sheet 16
    These ranges are from cell A8, and even the last row in column D
    hank you very much for the help
    Last edited by samahhamaad; 05-01-2016 at 09:04 PM.

  2. #2
    Registered User
    Join Date
    04-07-2016
    Location
    London
    MS-Off Ver
    2013
    Posts
    34

    Re: I need to code to clear contents the several fixed ranges of several sheets

    Hi,

    Try the below code, it will execute at time 23:00, you can change the Minute in the IF condition

    Please Login or Register  to view this content.
    Thanks & Regards,
    Vidhya
    Last edited by vidhyakrr; 05-01-2016 at 08:18 PM. Reason: Entering the code tags

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: I need to code to clear contents the several fixed ranges of several sheets

    @vidhyakrr,

    Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    04-04-2016
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    21

    Re: I need to code to clear contents the several fixed ranges of several sheets

    Hi
    Dear Mr vidhyakrr
    I think it should put the code in the workbook
    happened to the event is activated as soon as the arrival time of 23:00 h
    But that is placed in the Module will not automatically force
    The problem in the presence of merged cells, despite my need them
    Thank you very much for good help
    Last edited by samahhamaad; 05-02-2016 at 01:52 PM.

  5. #5
    Registered User
    Join Date
    04-04-2016
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    21

    Re: I need to code to clear contents the several fixed ranges of several sheets

    Hi
    Any new ideas in this topic please

  6. #6
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: I need to code to clear contents the several fixed ranges of several sheets

    Can you just move the code to a Worbook_Open Event in "ThisWorkbook"

    But what your asking may be beyond VBA. The code will clear the workbook if Opened at 11pm. Or use a WorkSheet Change event? But what if the file is opened at 11:05?

  7. #7
    Registered User
    Join Date
    04-04-2016
    Location
    egypt
    MS-Off Ver
    2007
    Posts
    21

    Re: I need to code to clear contents the several fixed ranges of several sheets

    Dear Friend ptmuldoon
    Thank you very much
    Are not taken to open the workbook after eleven o'clock pm
    This example illustrates the problem in the deletion of all ranges with timely solutions
    The reason is the existence of merged cells
    which represent a an impediment to delete all ranges
    Thanks & Regards
    Attached Files Attached Files
    Last edited by samahhamaad; 05-03-2016 at 05:28 PM.

+ 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. VBA Code to clear contents
    By tubbs1969 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2016, 10:07 AM
  2. [SOLVED] vba to clear contents in specific ranges on active sheet
    By blackburnsexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2014, 09:35 AM
  3. VB Code to clear contents
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2014, 01:35 AM
  4. [SOLVED] Code to clear cell contents
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-15-2013, 10:29 PM
  5. Code to clear contents of specific cells based upon if key exists in other sheets
    By seputus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2013, 07:25 PM
  6. macro to clear contents of two ranges if cell is blank
    By fisher-price in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2011, 10:39 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