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?

Answers


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.


Need Your Help

Duplicate file descriptor with its own file offset

c windows linux unix file-descriptor

How can one create a new file descriptor from an existing file descriptor such that the new descriptor does not share the same internal file structure/entry in the file table? Specifically attributes

Do all the HTML5 storage systems work together?

html5 local-storage

While there are a lot of good stuff about html5, one thing I don't get is the redondant storage mechanism, first there is localstorage and sessionstorage, which are key value stores, one is for one