Select rows in worksheet based upon select criteria in a specific column and paste select cells from that row into the next available row in another worksheet. RRS feed

  • General discussion

  • I did this years ago. I think that I used a VB model to do this.  Any suggestions.  I have to use excel 2010.
    Tuesday, January 27, 2015 8:51 PM

All replies

  • Hello Fox,

    VSTO doesn't provide anything for that. That's why I'd suggest asking Excel specific questions on the Excel for Developers forum instead.

    Anyway, to select a cell or a range of cells, use the Select method. To make a single cell the active cell, use the Activate method.

    Wednesday, January 28, 2015 11:14 AM