Thanks Jim for taking the time. As I told Tom:
After developing the project further with more evaluation, I supect I'll go
the helper cell route. I have my project working OK for now but it's been
proven not reliable. Thanks to you both for taking the time. I'm sure this
will be of value to others.

Best Regards,
Greg


"Jim Cone" wrote:

Greg,

Ran Tom's macro on XL 97, 2000, 2002.
Used steps 1 3, 4 on all.
Also used step 2 on XL 97.
All of above on WindowsXP

My results agree with yours.
Failure is defined as the Msgbox showing "Nothing Selected"

Conclusions/opinions:
I think it's a "bug"
Change your code or scroll the sheet before calling the file open dialog.
MS won't fix it, but if they did issue a fix now, the problem
would still be there in the next release.

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware