|
Posted to microsoft.public.vb.ole,microsoft.public.vb.ole.automation,microsoft.public.dotnet.languages.vb,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|
|
Can't create AutoFiltered Excel worksheet using VB.NET
Sorry. I missed the title of the post...
--
HTH...
Jim Thomlinson
"Mike S" wrote:
Jim Thomlinson wrote:
Your syntax look a little off...
set rng = ws.Range("MyTableRange")
rng.AutoFilter
No. In VB.NET, the "Set" and "Let" keywords are not supported.
Therefore, when you are setting a reference to an object, you can't
type "Set x = y" anymore; instead you type "x = y", same as a normal
assignment. VB.NET code that uses "Set" or "Let" will not compile;
however, if you are using the Visual Studio .NET IDE to write your
code, the IDE will simply delete any "Set"s or "Let"s if you try to
type them, in order to save you from writing code that won't compile.
--
Mike S
|