Trouble-shooting a 'run-time error 91' with the definition of a range

I'm trying to gain a better feels for using ranges rather than trying to loop through cells and assign something dynamically that way; it seems more powerful, to me, to have a good understanding of how to define ranges and alter them dynamically. To this end I wrote the very small code below. This code gives me a "runtime error 91: object variable or with block variable not set."

I know it's simple for many, but if someone could give me an explanation as to why this error occurs, I would be very appreciative.

Here's the code...

Please Login or Register  to view this content.

from the error statement:

"runtime error 91: object variable or with block variable not set." [emphasis mine]

Your assignment statement neglects to include the "Set" keyword. Where the "Let" keyword is optional (and frequently left out) of Let statements, the Set keyword is not optional in Set statements https://msdn.microsoft.com/EN-US/lib.../gg251642.aspx

I think it should work just fine if you include the Set keyword when you assign the range to rng
Set rng=thisworkbook.....