Determine what you have selected in Excel

[ingrid]

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

[Al Smith]

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>

[ingrid]

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

ingrid

[ScottF]

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

[ScottF]

Can somebody help