Here’s a stackoverflow question that I’ve never seen before. And I’ve seen a lot of questions.
Set a Range variable that holds its state, such as a module-level variable. Then delete the row. Then inspect that variable in the Locals Window.
Dim r As Range
Set r = Sheet1.Range("A1")
I ran starttest, deleted row 1, then ran stoptest. The Locals Window looks like this:
It still points to a memory address and is not Nothing:
I think I’ve never seen this before because I’ve never had a range variable other than as a local variable in a procedure. It seems strange to me that I’ve never encountered that. I guess it could be useful to check if range was deleted. Anyway, I thought it was interesting.