Activesheet isn't special enough--it can be a worksheet, a chart sheet, a macro
sheet....

I like to do:

dim wks as worksheet
set wks = activesheet

wks.(and then I get the intellisense to help me)



K J Boland wrote:

When I write in VBA I have been used to seeing the available commands which
come next. This has stopped working - (i,e when I write ActiveSheet. and
hold the curser by the "," I don't see available commands).I think this is
the List Properties.

I have looked at the Options settings within VBA, and it all seems to be
O.K.

What can I do to get this function back ??

thanks in advance,

--

Dave Peterson