[RESOLVED] Set excel range in vb.net

[Herry Markowitz]

Hi experts,
I got following VBA code from this link;
http://www.ozgrid.com/forum/showthread.php?t=50354

Sub delHiddenRows() 
    Dim r As Range, k As Range 
    With ActiveSheet 
        Set r = .Range("A1:A" & .Cells.SpecialCells(xlCellTypeLastCell).Row) 
        Set k = r.SpecialCells(xlCellTypeVisible) 
        r.EntireRow.Hidden = False 
        k.EntireRow.Hidden = True 
        r.SpecialCells(xlCellTypeVisible).EntireRow.Delete 
        r.EntireRow.Hidden = False 
    End With 
End Sub

I am trying to change above VBA code to vb.net code.
When I copy following line to vb.net,

Set r = .Range("A1:A" & .Cells.SpecialCells(xlCellTypeLastCell).Row)

that line automatically change as following line by Visual Studio.

r = .Range("A1:A" & .Cells.SpecialCells(xlCellTypeLastCell).Row)

In other words the Set statement disappear in Visual Studio.

That line doesnt work in vb.net because Set statement disappear...

Any support will be appreciated...

[sapator]

Haven't done excel with .net (MS excel API's) in loooong time.
So you either do soemthing like

Dim r As new Range ' or ' Dim r As Range
r = .Range("A1:A" & .Cells.SpecialCells(xlCellTypeLastCell).Row)

There is not set in .net, or at least it's pleonasm, if is still used.
Or, if you have issues then the best bet would be to import the excel interop object in .net and use that to program.
Be aware that this will give tons of issues if you plan to use ASP.NET as reported by Microsoft itself, DO NOT use it in ASP.NET .

[Herry Markowitz]

Thanks sapator. Solved.