Declare variable memory allocation VBA
When we declare a variable or instantiate an object in VBA, is the memory that is allocated in the RAM memory, Cache memory or ROM memory?
It's in the RAM.
ROM means Read-Only Memory, so obviously you won't write there.
As far as I know, VBA doesn't decide what goes to cache and what doesn't.