-
N-sheets
以G列分成多个工作表(以宏运行VBA)
(Sub aa()
Dim a As Integer, b As Integer, c As Integer, sh As Worksheet
For a = 2 To [g65536].End(3).Row
If Cells(a, 7) <> Cells(a- 1, 7) Then
b = a
End If
c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row
Set sh = Sheets.Add(, Sheets(Sheets.Count))
sh.Name = Sheets("sheet1").Cells(a, 7).Value
With Sheets("Sheet1")
Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2]
Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1]
a = c
End With
Sheets("Sheet1").Select
Next
End Sub
)
- 2013-05-03 08:50:54下载
- 积分:1
-
Ogre_sjms
OGRE 3D引擎所含设计模式之分析
OGRE 3D引擎所含设计模式之分析(not)
- 2009-05-10 18:27:59下载
- 积分:1
-
eluosi
用c++编写的俄罗斯方块小游戏,有兴趣的可以学习下(With c++ Tetris game, interested can learn under)
- 2013-10-15 22:11:42下载
- 积分:1
-
DiskSectorExplorer02
win32/MFC编程入门级项目,磁盘扇区查看器,由于磁盘数据如果展示到界面上来,数据量是非常大的,所以做了分页处理 这是是毕业之前做的,高手请自动忽略(Win32/MFC programming entry level project, disk sector viewer, because disk data is displayed to the interface, the amount of data is very large, so do paging processing this is done before graduation, high hands please automatically ignore.)
- 2018-07-10 17:09:02下载
- 积分:1
-
PSCNC
说明: 一个雕刻机的源代码,还有编译好的程序,国外的(An engraving machine)
- 2021-04-22 22:58:49下载
- 积分:1
-
Factory
Factory 模式的两个最重要的功能:
1)定义创建对象的接口,封装了对象的建;
2)使得具体化类的工作延迟到了子类中。
(Factory mode two most important functions: 1) the definition of an object to create an interface that encapsulates the construction objects 2) makes specific class work delayed to subclasses.)
- 2016-07-11 10:53:39下载
- 积分:1
-
Newton
潮流计算,内部为GMRES和牛顿法构成的双层迭代,加有预处理(Flow calculation inside a double-iteration of GMRES and Newton' s law, plus pretreatment)
- 2013-01-04 11:12:23下载
- 积分:1
-
demo-it-master
what the test is it test to be tes
- 2019-01-22 22:27:27下载
- 积分:1
-
ooh323.tar
国际电信联盟提供的H.323协议。文件包含所有实现源代码,全部可以编译通过。(The source code of H.323 protocol.)
- 2009-10-29 10:01:15下载
- 积分:1
-
MU1.03tuoji
很不错的一个奇迹(MU)脱机外挂,支持手动添加捡取任何物品。自动上线。(A nice miracle (MU) is out of the machine, supporting manual addition of picking up any items. Automatic online.)
- 2020-07-02 04:00:01下载
- 积分:1