Post Closed as "Duplicate" by GSerg vba

occurred Apr 4, 2021 at 10:19

deleted 16 characters in body

edited Dec 28, 2015 at 8:34

Hopefully an easy question, but I'd quite like a technical answer to this!

What's the difference between:

i = 4

and

setSet i = 4

in VBA? I know that the latter will throw an error, but I don't fully understand why.

Many thanks!

Hopefully an easy question, but I'd quite like a technical answer to this!

What's the difference between:

i = 4

and

set i = 4

in VBA? I know that the latter will throw an error, but I don't fully understand why.

Many thanks!

Hopefully an easy question, but I'd quite like a technical answer to this!

What's the difference between:

i = 4

and

Set i = 4

in VBA? I know that the latter will throw an error, but I don't fully understand why.

edited tags

edited Apr 19, 2012 at 17:29

asked Dec 8, 2008 at 13:54

What does the keyword Set actually do in VBA?

Hopefully an easy question, but I'd quite like a technical answer to this!

What's the difference between:

i = 4

and

set i = 4

in VBA? I know that the latter will throw an error, but I don't fully understand why.

Many thanks!

Return to Question