使用如下宏代码:
Sub ReplaceHeadEnd()
Dim StRow as long,EndRow as long,StCol as long ,EndCol as long
ActiveSheet.UsedRange.Select
StRow=ActiveSheet.UsedRange.Row
EndRow=StRow+ActiveSheet.UsedRange.Rows.Count-1
StCol =ActiveSheet.UsedRange.column
EndCol =StRow+ActiveSheet.UsedRange.columns.count-1
for pi=stcol to endcol
activesheet.cells(StRow,Pi)=Repace(ActiveSheet.Cells(StRow,Pi),"查找的字符串","替换为新的字符串")
activesheet.cells(EndRow,Pi)=Repace(ActiveSheet.Cells(EndRow,Pi),"查找的字符串","替换为新的字符串")
Doevents
next
msgbox "处理完毕!" & vbCrLf & "更多批处理功能,请参见百宝箱V10.0",vbinformation+vbOkOnly,"消息"
End Sub