Cannot Call a macro within a macro

[chasoe]

Dear experts,

I'm still a beginner in VBA, and only capable of doing cut & paste works to make my own macro.

I've completed the whole macro (which will call up another macro), but if I press F5 (from within the VBA Project) the codes can call up another macro and complete to the end. However if I press the macro hotkey (Ctrl+shift+o), it will stop before the line calling up another macro). I now list below my codes for your checking & advice :

Please Login or Register  to view this content.

Thanks in advance

Edward

[romperstomper]

Try using a shortcut key combination that doesn't involve the Shift key.

[chasoe]

Great ! The code really can finish to the end !
But why can't I use hotkey Ctrl+Shft, what is the logic behind ?

Thx anyway.

[romperstomper]

It's a bug in Excel.

[chasoe]

Thanks so much for your advice !