Help: How to pass a cell matrix as a variable in the arguments of a VBA function - Programming版

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Programming版 - Help: How to pass a cell matrix as a variable in the arguments of a VBA function

相关主题
● 如何在c++里定义一个map of map
● Please Help me with this Excel VBA problem //bow
● 在Excel VBA里面定义global variable。
● how to proof (转载)
● 如果python command line positional arguments 里有些是运算，那这种argument 该怎么处理？
● How to get button name? (转载)
● c function 在 c里调用和C++调用结果不一样
● 请教php function在child theme中的重写
● register variable
● lambda的一个疑问

相关话题的讨论汇总
话题: vba话题: cell话题: variable话题: matrix话题: function

进入Programming版参与讨论

(共1页)

n********u
发帖数: 5

I need to pass a cell matrix with variable size (m X n) to a own defined VBA
fuction myfun(dataRange as Range). In this function the selected cell
matrix will be stored in an data array. I used to use Range.CurrentArray or
Range.Value2 to store the data into an assigned array variable successfully.
However, it requires the cells contain no formula. If the data in the cells
are obtained by a formula, everything screws up.
The code is shown below:
‘The function stores the data in selected cell mat

(共1页)

进入Programming版参与讨论

相关主题
● lambda的一个疑问
● sql 数据是存在哪里 (转载)
● 请问call by name是不是C编译器都没实现
● How to fix this? /bin/ls: Argument list too long
● matlab: how to set defaul value for function arguments
● static如何作为函数？
● 来几个C++测试题
● two c++ interview questions! (转载)
● C -- sample without replacement
● one more interview question

相关话题的讨论汇总
话题: vba话题: cell话题: variable话题: matrix话题: function

boards