Why I get "Object required" debug error (Beginner level)

Hello,
I get "Object required" debug error for line: "arrData = tbl.Data", 7th from bottom.
after I started calling Maybe_So method. What I have to write, where to declare object and what object?
Thank you.

Please Login or Register  to view this content.

tbl is a variable that is local to Sub Gordon and so is not in scope for Maybe_So. My first advice is that I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors and would have caught your error.

Second, you must make tbl available to Maybe_So. The best practice is to pass it as an argument.

Please Login or Register  to view this content.