I am working with a macro, which prints the dispatch guides. He does it correctly, but when I'm going to print one followed by another, the first one is repeated.
See in the image that I was repeated the branches Llanquihue and Osorno.
I added a set to the variable stored by the branch, but it is not solved
Sub creadorGD()
Dim application
Dim connection
Dim userID
Dim GridView As Object
Set objsheet = ActiveWorkbook.ActiveSheet
Set sucursal = Range("C7")
Call limpia
H = Range("B7")
sucursal = Range("C7")
I hope you can help me. Thanks as always
Greetings