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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 21:03:30  来源:igfitidea点击:

Syntax for a cell in vba

excelapivbasyntaxcell

提问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 对象模型文档的参考