yy5560的博客

Split(expression, [ delimiter, [ limit, [ compare ]]])参数 含义express 需要拆分的字符串delimiter 参数为拆分的分隔符，如果省略则使用空格做为分隔符limit 指定返回字符串的数量compare 指定拆分子字符串时的比较类型Sub d() Dim a As String Dim b Dim i As Integer a = "aaa bb cccc aaa ccc"...

excel表格处理当前工作表时，如果有几行中穿插着空白行，把下面代码复制进去，自动删除掉Sub DeleteBlankRow() Dim IngFirstRow As Long Dim IngLastRow As Long Dim a As Integer IngFirstRow = ActiveSheet.UsedRange.Row IngLastRow = IngFirstRow + ActiveSheet.UsedRange.Rows.Count ...

Sub Main()Cells(2,2).Interior.ColorIndex = 3End Sub