Hi there I am trying to create a function which uses the solver function and then calling this function in a sub which will eventually loop through a number of instances. I have tried to set up the sub for a single instance as a test but I am getting a runtime error 438 method range of object worksheet failed. Please see code below: