Article View: cn.bbs.comp.lang.visual-basic
Article #20663�ҵõ�excel����Ч������Ϊʲô��������
From: Ŭ�����ܶ�
Date: Mon, 11 Aug 2003 06:44
Date: Mon, 11 Aug 2003 06:44
22 lines
1675 bytes
1675 bytes
Dim nFirstRow As Integer
Dim nFirstCol As Integer
nFirstRow = ActiveSheet.UsedRange.Rows(1).Row ' ��һ��Ч��
nFirstCol = ActiveSheet.UsedRange.Columns(1).Column ' ��һ��Ч��
Dim nRowsCount As Integer
Dim nColsCount As Integer
nRowsCount = ActiveSheet.UsedRange.Rows.Count ' �����
nColsCount = ActiveSheet.UsedRange.Columns.Count ' �����
Dim nLastRow As Integer
Dim nLastCol As Integer
nLastRow = nFirstRow + nRowsCount ' �������
nLastCol = nFirstCol + nColsCount ' �������
�����ӵõ���������Ч�������DZ�ʵ�ʵĶ࣬Ϊʲô
--
[m[1;37m�� ��Դ:��BBS ˮľ�廪վ smth.org��[FROM: 203.207.195.99][m
Technical Details
Message-ID:
<000000$48q@smth.org>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-09!supernews.com!newsfeed.news2me.com!elnk-nf2-pas!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!SMTHShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,GB X-Google-Thread: 109fdd,1131a15f08c573fa,start X-Google-Attributes: gid109fdd,public X-Google-ArrivalTime: 2003-08-10 23:45:06 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-09!supernews.com!newsfeed.news2me.com!elnk-nf2-pas!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!SMTH From: bravura@smth.org (Ŭ�����ܶ�) Newsgroups: cn.bbs.comp.lang.visual-basic Subject: �ҵõ�excel����Ч������Ϊʲô�������� Date: 11 Aug 2003 06:44:54 GMT Organization: BBS ˮľ�廪վ Message-ID: <000000$48q@smth.org> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: VisualBasic/E/M.1060584074.n0 Lines: 22