I am using vb.net 2005 to fill a spreadsheet in excel with data. I
have gotten the data in the speadsheet and now I am not to formatting.

I can change text justification by:

..HorizontalAlignment = 3 'Centers Text in the cell

I am having trouble with the borders. I have searched the group and
recorded macros and found things like .xlEdgeBottom and changing the
..LineStyle, .Weight, etc... properties.

Is there a way to get vb to recognize the .xlEdgeBottom and .LineStyle
etc. instead of having to figure out the integer equivalents like I
did with the text justification?

There are many more properties for the border than there was for text
justification so trying all the possibilities will take a lot more
time.

Thanks