| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error after calling a procedure
Here is a segment of my code:
InsertSpectrum ActiveSheet.Range(Cells(12 + j, 22), Cells(12 + j, 35)).Value = _ ActiveSheet.Range("V10:AI10").Value where InsertSpectrum is another procedure in the same project. The 2nd line does not execute; instead, I get an error "Run-time error '1004': Method 'Cells' of object '_Global' failed". If I remove the call to InsertSpectrum, the next line executes properly. What can I check to correct the problem, so that the second line will run after the procedure call? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time Error '5' - Invalid procedure call or argument | Excel Discussion (Misc queries) | |||
| Run-time error '5': Invalid Procedure Call or Argument | Excel Discussion (Misc queries) | |||
| Run Time Error 5 - Invalid Procedure Call or Argument Q | Excel Programming | |||
| Calling a procedure in a procedure | Excel Programming | |||
| Run-time error '5':Invalid Procedure call or argument | Excel Programming | |||
Threaded Mode
