我在excel电子表格中有以下内容和更多内容:
service instance 404 ethernet
description Name 661-1-11-3-15
encapsulation dot1q 804 second-dot1q 4
rewrite ingress tag pop 2 symmetric
bridge-domain 804 split-horizon
service instance 405 ethernet
description Name 661-1-11-4+1
encapsulation dot1q 804 second-dot1q 5
rewrite ingress tag pop 2 symmetric
bridge-domain 813 split-horizon
service instance 408 ethernet
description Name 661-1-12-1-4
encapsulation dot1q 804 second-dot1q 8
rewrite ingress tag pop 2 symmetric
bridge-domain 823 split-horizon我需要让它看起来像下面这样:
service instance 404 ethernet
description Name 661-1-11-3-15
encapsulation dot1q 804 second-dot1q 4
rewrite ingress tag pop 2 symmetric
bridge-domain 804 split-horizon
service-policy input platinum-up
service-policy output platinum-dn
service instance 405 ethernet
description Name 661-1-11-4+1
encapsulation dot1q 804 second-dot1q 5
rewrite ingress tag pop 2 symmetric
bridge-domain 813 split-horizon
service-policy input platinum-up
service-policy output platinum-dn
service instance 408 ethernet
description Name 661-1-12-1-4
encapsulation dot1q 804 second-dot1q 8
rewrite ingress tag pop 2 symmetric
bridge-domain 823 split-horizon
service-policy input platinum-up
service-policy output platinum-dn基本上,对于每个数据集之间的每个空白行,将插入两行数据('service-policy输入白金‘和’服务策略输出白金-dn‘)和一个空行。有没有人可以向我展示一种比插入两个空行并将数据复制到空格中更简单的插入数据的方法?
谢谢,J. R。
发布于 2014-08-26 05:45:14
非常简单。
Sub InsertLines()
Dim Row As Long
ActiveSheet.UsedRange
Row = 6
Do
Range(Cells(Row, 1), Cells(Row + 1, 1)).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Cells(Row, 1).Value = " service-policy input platinum-up"
Cells(Row + 1, 1).Value = " service-policy output platinum-dn"
Row = Row + 8
Loop Until Row > ActiveSheet.Cells.SpecialCells(xlLastCell).Row + 1
End Subhttps://stackoverflow.com/questions/25494166
复制相似问题