
October 14th, 2003, 03:46 AM
|
 |
Junior Member
|
|
Join Date: Aug 2003
Location: Austria
Posts: 17
Time spent in forums: 6 sec
Reputation Power: 0
|
|
Undefined Code Jumps in VBA
I've got a very strange problem ...
I want to copy a region of an excel sheet, and paste it as a new slide in a powerpoint presentation ... that would regularly be achieved by the following code:
Range(sPrintArea).Copy
Set ppShapeRange = ppSlide.Shapes.Paste
BUT:
While executing the second command (paste) VBA jumps to a totally other region of the code, in my case into the error region of another function in another module. And it's no use setting a breakpoint over there, because the program doesn't get past this point  , although it's executing exactly this code.
Does anybody have a clue what this phenomena could be or how and where I can get a solution for it ? Thanks for any help ...
Wolfgang
|