isError() is a function that will return either True or False, you can't assign a value to it. Why don't you try:
If IsError(Selection.Find(what:=portfolio)) Then
....
Hello,
On a regular basis we have to run some sheets manually, copying and pasting the parameters to run the formulae. I am trying to automate it, but I have no access to the code behind the sheet, so I have come around this issue using SendKeys to virtually click on the buttons for me (I don't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.