I'm creating a tool in Excel with an external database. The database userform and buttons work, but when i go forward to other userforms and i return to the database i receive this runtime error when using one of the buttons.
The code that i use to determine the range works when activating the userform, but not when i return to the userform.
This line creates the error:
Set MyData = Ws.Range("A5").CurrentRegion.Offset(1)
According the internet the appropriate object variable is missing.
Do somebody know how to solve this?