Given this simple code Code: Application.EnableEvents = False wsMon.Activate wsMon.Range("C2:L2").ClearContents Application.EnableEvents = True what in the world could cause a runtime error 1004- ClearContents method of Range class failed?
Application.EnableEvents = False wsMon.Activate wsMon.Range("C2:L2").ClearContents Application.EnableEvents = True
Tips, Examples & Tutorials: A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners 2009 - 2016
Forum Rules
2009 - 2016
Reply With Quote