none
VBA's Union, Intersection, and Specialcells in VB RRS feed

  • Question

  • Hello,  I am converting an XLAM add-in for Excel to a VSTO Excel 2010 Add-in template in VB.  I need to use VBA's Union, Intersect, and SpecialCells methods.  Are there analogous methods in VB?.. or is there a VBA reference I can include in my project to have access to these methods?

     

    Thanks

    Wednesday, August 10, 2011 4:10 AM

Answers

  •  

     Globals.ThisAddIn.Application.Union()
     Globals.ThisAddIn.Application.Intersect()
     Globals.ThisAddIn.Application.ActiveCell.PasteSpecial()
    

     Globals.ThisAddIn.Application.ActiveCell.SpecialCells()

     I think there's no big differences between VBA method and VB method.

     I hope this helps

     


    http://vsto.tistory.com

    Wednesday, August 10, 2011 5:39 AM