visual studio 2010 - formatting excel cell borders in vb.net -

hi i'm pretty new in generating excel reports using visual studio 2010 , having trouble finding right code put border on bottom of cell. far have code works fine put borders.

      wsheet.cells(9, itemcount + 2).borders.linestyle = excel.xllinestyle.xlcontinuous 

try this

wsheet.cells(9, itemcount + 2).borders(xledgebottom).linestyle = excel.xllinestyle.xlcontinuous 

also refer this more detailed