Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using A Macro To Add Event Procedure To A CommandButton
Bob, Thanks for trialing the code for me. To get round the memory
error I changed to code to use .InsertLines (which does inc the +1)(see next post from myself). The code works well for a trial workbook I used but when I use it on the workbook where I actually want the new button I get a Run-time error 9 : Subscript Out of Range when I try and run the With ActiveWorkBook......line. As far as I can see the with statement doesn't reference anything particular to my trial file....should I have a dim statement or something? I still need to find a way of getting d="E1" rather than d=E1 in my commandButton code. Any ideas anybody? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using A Macro To Add Event Procedure To A CommandButton | Excel Programming | |||
Using A Macro To Add Event Procedure To A CommandButton | Excel Programming | |||
How to write a macro to import an event procedure to ThisWorbook? | Excel Programming | |||
Using A Macro To Add Event Procedure To A CommandButton | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |