I want to pick up the sheetname from cell Z14 of a sheet called Summary.
This is my original code
Set Found = Sheets("Sheet11").Range("A4:A85").Find(what:=.Range("E2").Value, lookat:=xlWhole, LookIn:=xlValues)
I tried replacing ("Sheet11") with this but I don't seem to have it working correctly
Set Found = Sheets(Sheets("Summary").Range("Z14").Value).Range("A4:A85").Find(what:=.Range("E2").Value, lookat:=xlWhole, LookIn:=xlValues)
Can anyone assist?
This is my original code
Set Found = Sheets("Sheet11").Range("A4:A85").Find(what:=.Range("E2").Value, lookat:=xlWhole, LookIn:=xlValues)
I tried replacing ("Sheet11") with this but I don't seem to have it working correctly
Set Found = Sheets(Sheets("Summary").Range("Z14").Value).Range("A4:A85").Find(what:=.Range("E2").Value, lookat:=xlWhole, LookIn:=xlValues)
Can anyone assist?