Although there isn’t a syntax, you can still get close by using the built-in block comment buttons: If you’re not viewing the Edit toolbar already, right-click on the toolbar and enable the Edit toolbar: Then, select a block of code and hit the “Comment Block” button; or if it’s already commented out, use the “Uncomment … Read more
I believe you are having the same problem here.The sheet must be active before you can select a range on it. Also, don’t omit the sheet name qualifier: Or, which is the same.
The error you are getting means that there are cells near the ones in your formula that are of a similar format and Excel thinks that you might have missed them by accident. For example, if you had then the formula would give a similar error. So, without seeing your source data, it is difficult … Read more
I would suggest to use SUMPRODUCT rather than SUMIFS. You can build something like that : The downside of SUMPRODUCT is that you can’t use a whole column (for example you cannot write SUMPRODUCT((B:B=”Sales”…)), this would generate an error). Hope this helps.
Perhaps your code is behind Sheet1, so when you change the focus to Sheet2 the objects cannot be found? If that’s the case, simply specifying your target worksheet might help: I’m not very familiar with how Select works because I try to avoid it as much as possible :-). You can define and manipulate ranges … Read more
Use a criteria of “<>”. It will count anything which isn’t an empty cell, including #NAME? or #DIV/0!. As to why it works, damned if I know, but Excel seems to understand it. Note: works nicely in Google Spreadsheet too
For BIFF .xls files For Excel2007 and above .xlsx files
Your error is caused by these: These types, Table and Row are not variable types native to Excel. You can resolve this in one of two ways: I have not tested your code but I suspect ActiveDocument won’t work in Excel with method #2, unless you properly scope it to an instance of a Word.Application object. I don’t see that anywhere … Read more
The way to get the results of your formula would be to start in a new sheet. In cell A1 put the formula Copy that cell down to row 40 In cell B1 put the formula In cell B2 put the formula Copy that cell down to row 40. The value you want is now … Read more
Try using the InStr function which returns the index in the string at which the character was found. If InStr returns 0, the string was not found. InStr MSDN Website For the error on the line assigning to newStr, convert oldStr.IndexOf to that InStr function also.