Ok so i want to build an Excel plugin (custom task pane) that'll act on the selected range in the active worksheet.
Can't find any examples or documentation on how.
In addition to the references Mitch listed, I wrote an Excel VSTO add-in tutorial which uses a custom task pane to find differences between sheets and navigate to cells with differences on the active worksheet. Hopefully you'll find it helpful!