Peter,
Yes there is also trouble here in River City. <g
Thanks for providing the links.
Regards,
Jim Cone



"Peter T" <peter_t@discussions
wrote in message
Hi again,
I guessed this issue (CF's with Inputbox) must have been reported somewhere
and indeed it has -
http://www.jkp-ads.com/articles/SelectARange.asp
It also seems the issue is far more prevalent than I realised, not only with
IsFormula but any type of CF, see other links on Jan Karel Pieterse's page.

However I don't think RefEdit, as cited, is the only viable workaround,
Inputbox with Type:=0 works fine (see example posted to Pflugs).
Regards,
Peter T


"Jim Cone"
wrote in message
Hi Peter,
Thanks for the info.
I tried using Average in a CF formulas without a problem and am
finding the desire to go thru 200? or so functions is pretty low.
I always check that the return value is a range and think I will just
"let it ride".
Regards,
Jim Cone


"Peter T" <peter_t@discussions
wrote in message
Hi Jim,
With IsFormula CF's that include a worksheet function in the formula,
InputBox Type:=8 can fail to return a range.

No problem to return a formula with Type:=0. It will be in R1C1 format,
parse out the "=", ConvertFormula from R1C1 to A1 style, set the range.
Include some error handling for 'False' or an invalid address and away you
go.
Similar type CF's may affect other things such as GetOpenFileName.
Regards,
Peter T


"Jim Cone"
wrote in message
Hi Peter,
In regard to...
"I don't use type:8 ... but the formula method to avoid a bug with
particular CF's"

What did you find with conditional formatting that affects returning a
range object from an Input Box?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins)