| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED
DEAR ALL
I wrote a lengthy program and each step was checked using function-8. but when command button was used get the following error at location ActiveSheet.Paste Link:=True ERROR 1004 paste method of worksheet class failed I used on error resume but the results are disastrous as too many cells are left uncopied or formulas not written. Can anyone guide me?? what could be the reason.?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED
Standard response is to try setting the "takefocus on click" property of the
button to False. If that doesn't work then post some code. Tim "CAPTGNVR" wrote in message oups.com... DEAR ALL I wrote a lengthy program and each step was checked using function-8. but when command button was used get the following error at location ActiveSheet.Paste Link:=True ERROR 1004 paste method of worksheet class failed I used on error resume but the results are disastrous as too many cells are left uncopied or formulas not written. Can anyone guide me?? what could be the reason.?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing a command button from being clicked twice | Excel Discussion (Misc queries) | |||
| Command Button does not re-set once clicked | Excel Programming | |||
| Automation error -2147417848 on windows 98 while using excel in VB ( works fine in XP) | Excel Programming | |||
| Detrmine which command button was clicked | Excel Programming | |||
| RPC ERROR - 1ST TIMES WORKS FINE - 2ND TIME ERRORS OUT | Excel Programming | |||
Hybrid Mode
