If you have access to the XL application in your add-in (say its called
xlApp), you could always use xlApp.Selection. Verify its type is Range
and then do whatever it is you want to do with it.

Personally, when I start a new add-in, I often rely on things like the
selection. But before I unleash it on an unsuspecting world, I always
replace the interface with a userform (windows form in .Net?)


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , tierscheiss1977
@hotmail.com says...
I've gotten the Com Addin to work, my problem is this. I need to allow
the user to select a range of cells (All in the same column) and then
select my addin. My addin needs to pick up this range of cells and
then parse the value of each cell in this range. I have looked, and
though I had it, but nadda.
I am using VB.NET to create the addin.

Thanks,
Jody W