Excel Range Selection Problem - Input box returns the string not the range !

[Kasim GULCAN]

Hi,
I'm using the following code to allow user to define a range for my add-in,
oExcel.InputBox(Prompt,Title,Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, 8);

It works for 99% but not 100% because sometimes it returns the address of
the range but not itself.

Have any idea ?

Kâsým

 

[Nick Hebb]

Is this at normal runtime, or when testing from the IDE? I've had
buggy behavior calling InputBox from VB6 when I run in the IDE but it
works fine when compiled.


- Nick

 

[Kasim GULCAN]

This problem occurs in the runtime :
-
NULL