Ray,
In Excel, ActiveSheet does not have to be a worksheet. It can be a Chart or
Macro sheet.
As such, you do not get Intellisense when using it as it's possible members
are not known until runtime.
Not sure how this appears in VSTO.
But ActiveSheet.Range("A1").Value=100 is certianly valid VBA.

Also, "Sheet" is a member of the PublishObject, but again don't know if
using an object name in VSTO is the cause.

NickHK

"Ray Price" wrote in message
...
The VSTO API reference says that the worksheet object has a range
property...


http://msdn2.microsoft.com/en-us/lib...(VS .80).aspx

But in my code I have...
Excel.Worksheet sheet = Application.ActiveSheet;

but then

Sheet.Range does exist

Anyone know what's going on here? I am quickly losing patience with VSTO.



Thanks