Determine Selected Cells

[John Tripp]

In a VBA macro how do I determine the current selected
range. I am sure this is trivial, but I am having no luck
finding an example of code to do this.

Thanks for any help.

John

 

[Bob Phillips]

John,

If you want to determine if a particular cell is selected, use something
like

If Not Intersect(Selection, Range("B99") Is Nothing Then
...

or

If Not Intersect(Selection, Range("B99:B100") Is Nothing Then
...

 

[John Tripp]

-----Original Message-----
In a VBA macro how do I determine the current selected
range. I am sure this is trivial, but I am having no luck
finding an example of code to do this.

Thanks for any help.

John
.