I have some macro that runs on my current sheet, but I'd like it to run across all tabs in my workbook with the click of a button. Its purpose is to replace all values indicated in f5 with the value in f6, in cells A2:C100.
This is the current code:
Sub try()
Range("A2:C100").Select
Selection.Replace What:=Range("f5").Value, Replacement:=Range("f6").Value, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Sub Button4_Click()
End Sub
No comments:
Post a Comment