Excel : how to find corresponding constants name in vb . net ?

[François]

Hello,
I'm currentry porting a vba project into vb .net
Things are going smoothly for the moment, but I'm loosing a lot of time to
find the counterparts constants name for ex :
ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
can I find the corresponding constant in vb.net ?
Many thanks

[François]

Another ex :
With ThisApplication.Selection.Validation
.Delete()
.Add(Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=Remarks")

xlValidateList, xlValidAlertStop, xlBetween ????

I have tried to search those with excel.Constants which give constants name
but not able to find ....

"François" wrote:

Hello,
I'm currentry porting a vba project into vb .net
Things are going smoothly for the moment, but I'm loosing a lot of time to
find the counterparts constants name for ex :
ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
can I find the corresponding constant in vb.net ?
Many thanks

[Paul Clement]

On Fri, 4 Mar 2005 04:51:01 -0800, François <Fr*****@discussions.microsoft.com> wrote:

¤ Hello,
¤ I'm currentry porting a vba project into vb .net
¤ Things are going smoothly for the moment, but I'm loosing a lot of time to
¤ find the counterparts constants name for ex :
¤ ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
¤ can I find the corresponding constant in vb.net ?
¤ Many thanks

Have you looked in the Object Browser for Microsoft.Office.Interop.Excel.Constants?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[François]

Yes, finally it seems that it is the only solution. Missing a find like 'in
vba' to be quicker ....

Thanks for your answer.

"Paul Clement" wrote:

On Fri, 4 Mar 2005 04:51:01 -0800, François <Fr*****@discussions.microsoft.com> wrote:

¤ Hello,
¤ I'm currentry porting a vba project into vb .net
¤ Things are going smoothly for the moment, but I'm loosing a lot of time to
¤ find the counterparts constants name for ex :
¤ ActiveCell.SpecialCells(xlLastCell).Select -> xlLastCell constant ??? where
¤ can I find the corresponding constant in vb.net ?
¤ Many thanks

Have you looked in the Object Browser for Microsoft.Office.Interop.Excel.Constants?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)