vba vba中单元格的语法
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/16482337/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Syntax for a cell in vba
提问by JahKnows
I ma just starting up with VBA and I have come into quite a bit of trouble with the Syntax. Is the format for a cell in vba, (column, row) or (row,column)?
我刚开始使用 VBA,并且在语法方面遇到了很多麻烦。vba中单元格的格式是(列,行)还是(行,列)?
Is there a conclusive API for VBA similar to the API on the Oracle site for Java?
是否有类似于 Oracle 站点上用于 Java 的 API 的决定性 API 用于 VBA?
回答by Alex K.
Assuming Excel.
假设 Excel。
There is VBA the language which is one thing, and then there is how the application hosting VBA (Excel, Word etc) exposes itself to VBA (via its Object Model) which is what your specific question relates to.
VBA 语言是一回事,然后是托管 VBA(Excel、Word 等)的应用程序如何将自己暴露给 VBA(通过其对象模型),这与您的具体问题相关。
The argument order is:
参数顺序是:
.Cells(row, column)
(http://msdn.microsoft.com/en-us/library/ff196273(v=office.14).aspx)
( http://msdn.microsoft.com/en-us/library/ff196273(v=office.14).aspx)
See Referencesfor VBA and Excel Object Model documentation by version.
按版本参阅VBA 和 Excel 对象模型文档的参考。