-
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
-
INIT
_init_方法示例,通过一个简单的例子对init方法进行通俗化的解释(Example of _ init_ method)
- 2019-05-04 15:15:44下载
- 积分:1
-
OPF
这是简单的最优潮流程序,经过IEEE4、IEEE14、IEEE30、IEEE118、IEEE1047系统测试的。(It is a simple optimal power flow program, after IEEE4, IEEE14, IEEE30, IEEE118, IEEE1047 system testing.)
- 2020-12-16 19:39:12下载
- 积分:1
-
知云翻译软件
说明: 很好的翻译软件,可以极其方便翻译外文文献并合成中文,方便选取(Good translation software, which is very convenient to translate foreign documents and synthesize Chinese, and easy to select)
- 2020-04-13 19:04:45下载
- 积分:1
-
EXCEL VBA
说明: excel vba类丛书,入门丛书,内容通俗易懂,便于快速理解和掌握(Don't be afraid that EXCEL VBA is actually a very simple)
- 2020-12-14 15:39:14下载
- 积分:1
-
Golf game sources. Operational system: DOS. Compiles OK in Quickbasic.
Golf game sources. Operational system: DOS. Compiles OK in Quickbasic.
- 2022-02-12 02:33:38下载
- 积分:1
-
Virtual serial port driver required conversion to open up the card and want a ne...
虚拟串口 驱动 需要转换卡 而且新开辟的要在串口附近-Virtual serial port driver required conversion to open up the card and want a new serial at the vicinity of
- 2022-09-19 06:00:03下载
- 积分:1
-
Python机器学习算法—赵志勇
说明: Python机器学习算法—赵志勇,包含电子版书籍和随书代码,供大家学习。(Python Machine Learning Algorithms - Zhao Zhiyong, including electronic books and accompanying codes for everyone to learn.)
- 2019-05-08 10:36:59下载
- 积分:1
-
0416
一些關於查詢的簡單源碼...........................................................................(On a simple query-source)
- 2009-04-30 06:36:03下载
- 积分:1
-
OLEN
说明: 控制旁瓣级的一种波束形成方法,与凹槽噪声法同原理(A beamforming method for controlling the sidelobe level is the same as the notch noise method)
- 2019-12-03 10:01:24下载
- 积分:1