Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 17th, 2017, 07:35 PM
Registered User
 
Join Date: Aug 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel 2013 VBA Macro Help

Hello,

Could someone please help me create a macro for excel, specifically a time driven macro that clears certain cells automatically every morning at 9:15am?

I have found this script that does the trick clearing the cells:

Sub sbClearCellsOnlyData()
Range("C6:C14").ClearContents
End Sub

But I do not know to make it time driven.

Your help means a lot.

Thank you
 
Old August 15th, 2019, 02:22 PM
Registered User
 
Join Date: Feb 2017
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Default Excel 2013 VBA Macro Help

I found this from an old post on WROX.
HTML Code:
https://p2p.wrox.com/excel-vba/71210-schedule-vba-macro-run-specific-time.html
there are other posts from other sites found on google.

I hope this helps.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing a VBA macro password in Excel utalwalk Excel VBA 2 December 22nd, 2013 11:38 AM
Excel auto export .dbf file through VBA - OFFICE 2013 woes Drivium Excel VBA 0 July 25th, 2013 10:57 AM
Application to run excel vba macro dyung2 Excel VBA 9 October 28th, 2009 10:57 AM
Save a file in CSV format thru Excel VBA macro roli2712 Excel VBA 1 July 11th, 2007 03:05 AM
speed up macro Excel VBA crmpicco Excel VBA 8 December 21st, 2005 11:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.