.Worksheets(1).[no suggestions, no intellisense]

The reason is that that Item method of Worksheets returns a
generic Object rather than a Worksheet type variable, even though
at run time it will always return a Worksheet object. Poor
typelib design by Microsoft.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Helmut Weber" wrote in message
...
Hi Sandy,

there isn't much to learn about it.

Dim oWrk As Workbook
With oWrk
.[suggestions, intellisense]
End With

Though Excel's demands for precise declaration
are higher as e.g. Word's demands.

Dim oWrk As Workbook
With oWrk
.Worksheets(1).[no suggestions, no intellisense]
End With

As opposite to:

Dim oWrk As Workbook
Dim oSht As Worksheet
Set oSht = oWrk.Worksheets(1)
With oSht
.[suggestions, intellisense]
End With

IMHO
HTH

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"