The borders of the selected range

Hi!

How I can find the borders of the selected range?
In particular: the first row/column and the last row/column
to realoze export form Excel?

It is my code...

Private Sub AxWebBrowser1_NavigateComplete2(ByVal sender As System.Object, ByVal e As AxSHDocVw.DWebBrowserEvents2_NavigateComplete2Event) Handles AxWebBrowser1.NavigateComplete2
On Error Resume Next
oDocument = e.pDisp.Document
oDocument.Application.CommandBars("Standard").Position = Microsoft.Office.Core.MsoBarPosition.msoBarTop
CheckBoxShowBar.Enabled = True
End Sub

The user select range for export...

...
oDocument.Worksheets(1). - ??????

...

Hi,

May be you can try this

Please Login or Register  to view this content.

-Fron-

I can't understand how I can use "Selection" in my VB 2005 code.

For example It is the working code

HTML Code: 

But how use "Selection" in it?

oDocument.Selection does't work.

this is your code:

Please Login or Register  to view this content.

under this code, add:
Selection.Borders
.
.
.
.
may be you can give it a try

Your 'oDocument' variable refers to a workbook while the 'selection' refers to application and not to workbook.

In other words,
you can do:

Please Login or Register  to view this content.

and not:

Please Login or Register  to view this content.

because in this case you don't have the variable to refer to application because you would write:

Please Login or Register  to view this content.

I hope it can help.

Regards,
Antonio