Thread: Two questions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Two questions

P.

Re Question [1] - The hotfix here seems to cure the problem...

http://support.microsoft.com/?kbid=291110
"XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control"
It also works for XL20002. I don't know about XL2003.

Regards,
Jim Cone
San Francisco, CA

http://support.microsoft.com/?kbid=291110

"P. Dileepan" wrote in message ...
[1] When I run the code with a user form with RefEdit
controls, when I click in the worksheet to highlight cell
ranges, the arrow keys, Control-Home key, etc. are not
working. Is there a setting that I have to initialize in
the code?
[2] I am using Application.Run "ATPVBAEN.XLA!Regress"
and it works fine. I want to know whether I have to give
only Range objects for Y and X range. Can I give array
objetcs for Y and X range?
Thank you.
-- Dileepan