Saturday, June 6, 2015

Run Macro across all Tabs in Excel File - One line macro code available?

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

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...