Hi,
I am trying to write code that will find something based on Combobox, and replace with the textbox value. I am trying to do this over an array of sheets.
I am using the following code:
Code
For Each Sheet In Array("Centre", "Consolidate", "Validate1")
Sheet.Cells.Replace what:=ComboBox1.Value, Replacement:=TextBox1.Value, _
LookAt:=xlWhole, SearchOrder:=xlByColumns, MatchCase:=True, _
SearchFormat:=False, ReplaceFormat:=False
Next Sheet
however I get the object required error on the
line
once I get this working I will also need to do the same on multiple excel tables (10 of them).
Thanks for your help