Determine what you have selected in Excel

Dear VB users,

I have a problem the find out what is selected in Excel.

- Opening Excel sheet in VB5,
- select a area,
- with Alt Tab back to the VB5 program,
- ?

Is it now possible that the VB5 program can find out the selection.

If yes, can somebody tell me how??

Nice regards,

Ingrid

Hi,

ActiveCell.Row for the selected cell's row.
ActiveCell.Column for the selected cell's column.
ActiveCell.Value for the data in the selected cell. etc.

Al.


------------------
A computer is a tool, not a toy.
<A HREF="mailto:[email protected]
[email protected]">[email protected]
[email protected]</A>

I can find only the top left coordinate, also needed is the bottom right coordinate, do you know the source?

ingrid

I try activecell.row but I get a error that that Object doesn't support this property or method '438'

Can somebody help