Article View: cn.bbs.comp.database
Article #377Re: ��̣�excel�����������
From: ��ϵ����*Shiyanʲôʱ�����*5������
Date: Mon, 16 Mar 2009 05:35
Date: Mon, 16 Mar 2009 05:35
27 lines
2118 bytes
2118 bytes
�ţ����ϣ�����c�����洢���ڣ��Ǿ���Ҫ�ڴ��뿪ͷ�ȸ����������������ȡ
����ֵ���ٷŵ��������档
�š���
�ǻ������������ļ��Զ����кꡭ��
�ø���
�� �� qqlover (��ϵ����*Shiyanʲôʱ�����*5������) �Ĵ������ᵽ: ��
: ���ṩһ����������Ҫ�õ���
: ���������C1�д洢��������ڣ���=today()�����ʾ��C2�洢ʮ�������ڣ���=toda
: y()+10,C3�洢=today����-10
: ȡ������ʽ����Ϊa1-a10
: alt+f11��VBE�༭�����½�ģ�飬��ģ��ҳ�����������´��룺
: Sub Macro1()
: 'ɾ��������ʽ����ԭ�и�ʽ
: Worksheets(1).Range("a1:a10").FormatConditions.Delete
: '��������Ϊʮ��֮��ĵ�Ԫ��ĸ�ʽ
: With Worksheets(1).Range("a1:a10").FormatConditions _
: .................������ʡ�ԣ�
--
[1;31mHebei
��������Զ��ů�ļ�
[0;1;5;36mqq����ϵ����[m
[1;33m��Ʒ����ӭ���� Tea ��
[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.26.99][m
Technical Details
Message-ID:
<4f2h9d$bGk@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,3467c2b584bbabf0 X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: qqlover.bbs@bbs.sjtu.edu.cn (��ϵ����*Shiyanʲôʱ�����*5������) Newsgroups: cn.bbs.comp.database Subject: Re: ��̣�excel����������� Date: 16 Mar 2009 05:35:53 GMT Organization: ��ˮ˼Դ Message-ID: <4f2h9d$bGk@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1237181655.A