<br/>Sub 删除空行()''''引用小刀的代码<br/> On Error Resume Next<br/><br/> Dim RowID As Integer<br/> Dim sMessage As String<br/> Application.ScreenUpdating = False<br/> ' * 错误源<br/> Dim sSource As String<br/> On Error GoTo Err_Handler<br/> For RowID = Range(Cells(1, 1), ActiveSheet.UsedRange).Rows.Count To 1 Step -1<br/> If Application.WorksheetFunction.CountBlank(Rows(RowID).EntireRow) = 256 Then ''工作表函数CountBlank(行号),计算该行空白单元格的数目<br/> Rows(RowID).Delete<br/> End If<br/> Next<br/>Exit_Label:<br/> On Error GoTo 0<br/> <br/> Exit Sub<br/>Err_Handler:<br/> sMessage = "运行出错!" & vbCrLf _<br/> & Err.Description<br/> ' * 显示友好的错误信息<br/> Call MsgBox( _<br/> Prompt:=sMessage, _<br/> Buttons:=vbExclamation)<br/> <br/> GoTo Exit_Label<br/> Application.ScreenUpdating = True<br/>End Sub<br/>
<p>这样改一下就可以输入你想要聊天的人的号码了!</p><p>Sub QQ聊天()<br/> Dim str As String<br/> str = InputBox("请输入对方的QQ号码!", "QQ聊天", "313755341")<br/> If str = "" Then Exit Sub<br/> CreateObject("InternetExplorer.Application").Navigate "<a href="http://wpa.qq.com/msgrd?V=1&amp;Uin">http://wpa.qq.com/msgrd?V=1&amp;Uin</a>=" & str & "&amp;Menu=yes"<br/>End Sub<br/></p>