#1
|
|||
|
|||
Selection.Interior cause runtime error
Hi guys
I've recently created an automatised Holiday list for my Enterprise. The Command Buttons were working fine and you could select the range and set the Color for the cell by pressing the button. But for some reason it doesnt work anymore today. Theres an error saying something like application- or objectdefined error with the runtimeerror number 1004. Do you have any idea what the Problem could be and how to fix it? I've read on the Internet that Excel has Problems with selection and multiple Registers/Tabs, so maybe ist somehow related to this. Sorry about my english, the Translation of the error is just some Translation i came up with... However, the Compiler Points to the Selection function of the button pressed. Here's the code I use for every button: Code:
Private Sub cmdFerienFeb_Click() Selection.Interior.ColorIndex = 3 Call CountNotAbsentFebruary End Sub EDIT: the macro is working just fine Thanks for your suggestions HalfNOoB |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
runtime error 1004 | gbaker | Excel Programming | 11 | 06-06-2012 05:23 AM |
Runtime error on Initialise Form | Amapola188 | Word VBA | 2 | 06-05-2012 12:50 PM |
Runtime Error 4120 in Word 2007 macro | Frankwlc | Word | 5 | 11-28-2011 01:54 AM |
Runtime error 91 | waldux | Word VBA | 1 | 03-04-2011 11:25 PM |
Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |