I write VBA in Excel once or twice a year. Thus, I use the immediat
window a lot to check every line I write.

Can someone explain the following in immediate window:
activesheet.name - give me OK result
activesheet. - does not give me a drop down of choices
activecell. - does give me a drop down of choices
activesheet.usedrange - gives me a run time error.

What is going on? Do I have wrong libraries or dlls being used? How d
I know, how do I check? How do you know which libraries ar
attached/in-use/available, whatever is the correct words?

Also, I thought I was using (always) VBA. About Help says I'm usin
VB6.3

--
dpenn
-----------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...fo&userid=1970
View this thread: http://www.excelforum.com/showthread.php?threadid=38175