I don't recognize that error--are you sure you copied the error text correctly?--and it doesn't seem to make sense in the context of your code. This line of code is inside the loop so I don't understand what you mean when you say this happens once the loop ends.
But you have a couple of other problems you should fix. Fixing these may resolve the other issue.
You have a logical redundancy. You have a Do Until Status <> "", which means if you are going into the loop, Status = "". But the first statement is to test If Status = "". If you reach this If statement, it will always be true. This does not cause an error but this If statement is not necessary.
You have a loop that exits when Status <> "", but you never update Status inside the loop. If you enter the loop the first time, you will never exit. My guess is that count is going to a high value which is causing your error.
You are assigning Range("C" & count).Value to the value of variable Stat but variable Stat is never assigned a value. It will always be null.
You have declarations like
I suspect you are not clear on the syntax of a Dim statement. Each variable in a Dim statement must have a data type, or the data type will default to Variant. In the first statement, for example, Status, Stat, ttle, will all be type Variant. Variable link will be String. repeat will be an Integer but count will be Variant.
Bookmarks