The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft.
Dim myChar As Char throws Compile Error: "User-defined type not defined" What reference should I include to use Char type?
vba excel excel-2013I have a dynamic table that is tied to a SharePoint list. At any given time only 1 column will be …
vba excel excel-2013I am getting following error. Compile error: The code in this project must be updated for use on 64-bit systems. …
excel vba 64-bit excel-2013I have the following function for checking whether column L contains the word "completed" and I use INDIRECT to be …
excel excel-formula excel-2013 excel-r1c1-notationAs mentioned in the title, is there a way from the web access of TFS 2015 to open a particular query …
tfs excel-2013 tfs-2015 tfs-web-accessBackground My code does some loops over ranges, however, each interaction should be performed in the range excluding the cell …
excel excel-2013 vbaI am getting a Run-time error'1004' error on the following line. With ActiveSheet.QueryTables.add(Connection:=connstring, Destination:=Range("$…
vba excel excel-2013 excel-web-query