Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
楼主: 兰色幻想

[VBA] 兰色原创:VBA数组入门学习一

[复制链接]
发表于 2010-2-25 15:22 | 显示全部楼层
回复

使用道具 举报

发表于 2010-2-25 15:24 | 显示全部楼层
回复

使用道具 举报

发表于 2010-2-25 15:45 | 显示全部楼层
回复

使用道具 举报

发表于 2010-2-26 10:40 | 显示全部楼层

这样也很好啊,平时有时间就可以上来看看啊,温故而知新。文字有文字的好处,视频有视频的优势。
回复

使用道具 举报

发表于 2010-2-26 10:55 | 显示全部楼层

Dim Arr(1 to 5,1 to 2)
回复

使用道具 举报

发表于 2010-3-2 12:42 | 显示全部楼层

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>兰色幻想</i>在2010-2-24 20:12:00的发言:</b><br/><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">建一排房子的方法</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US"><font face="Times New Roman"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>Dim Arr(9) </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">这是声明一个含</span><span lang="EN-US"><font face="Times New Roman">10</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">元素的</span><span lang="EN-US"><font face="Times New Roman">VBA</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">数组,第一个数的位置是</span><span lang="EN-US"><font face="Times New Roman">Arr(0) </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第二个数位置是</span><span lang="EN-US"><font face="Times New Roman">Arr(1)…</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">最后一个数位置是</span><span lang="EN-US"><font face="Times New Roman">Arr(9)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US"><font face="Times New Roman"><span style="mso-spacerun: yes;">&nbsp;&nbsp; &nbsp; </span>Dim Arr(1 to 9) </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">这是声明一个含有</span><span lang="EN-US"><font face="Times New Roman">9</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">个元素的数据,第一个数据位置是</span><span lang="EN-US"><font face="Times New Roman">Arr(1),</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第二个是</span><span lang="EN-US"><font face="Times New Roman">Arr</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">(2)....<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">最后一个数是</span><span lang="EN-US"><font face="Times New Roman">Arr(9)</font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;"><span lang="EN-US"><font face="Times New Roman">建二排以上房子的方法:</font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><span lang="EN-US"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp; <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>Dim Arr(1 to 10,1 to 3) </span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">建一个三列十排的房子</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;">&nbsp;&nbsp;&nbsp; 如果是建2排5行的数组(房子), 该怎么建呢? 大家跟贴回一下吧,</p></font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>Dim Arr(1 to 10,1 to 3) </span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">建一个三列十排的房子</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;">&nbsp;&nbsp;&nbsp; 如果是建2排5行的数组(房子), 该怎么建呢? 大家跟贴回一下吧,</p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span>Dim Arr(1 to 10,1 to 3) </span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">建一个三列十排的房子</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;">&nbsp;&nbsp;&nbsp; 如果是建2排5行的数组(房子), 该怎么建呢? 大家跟贴回一下吧,</p></div><p>如果是建2排5行的数组(房子):Dim Arr(1 to 5,1 to2)&nbsp; 1 to 5&nbsp; 代表行&nbsp; 1 to 2 代表列&nbsp; 对吗?</p><p></p>
回复

使用道具 举报

发表于 2010-3-2 18:28 | 显示全部楼层
提示: 作者被禁止或删除 内容自动屏蔽
回复

使用道具 举报

发表于 2010-3-4 23:18 | 显示全部楼层

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>溦兰</i>在2010-2-24 20:29:00的发言:</b><br/>好象是60维,是吧?</div><p></p>学习完20楼了,60维,我是看见兰版在新论坛说的。
回复

使用道具 举报

发表于 2010-3-5 11:51 | 显示全部楼层

这样可以方便没时间上UC的同学学习,谢谢
回复

使用道具 举报

发表于 2010-3-8 21:47 | 显示全部楼层

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>溦兰</i>在2010-2-24 21:41:00的发言:</b><br/>谢谢,兰版,没问题啦,这次学到不少新知识,也刷新了原来认识的一些知识,好玩哦,下次课是什么时间呀?</div><p></p>我也好好期待呀
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-6-2 07:12 , Processed in 0.492683 second(s), 6 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表