Problem using 'Set' to set variable

[terrypin]

This has me baffled. The following code works fine. But I've been trying to get into the habit of using Set when setting a variable.

Please Login or Register  to view this content.

So I changed the bold line accordingly, to:

Please Login or Register  to view this content.

But to my surprise it then failed, highlighting 'dte =' with the error "Compile error: Object required".

[CK76]

You can't set a variable that isn't an object.

Please Login or Register  to view this content.

Is a value and not object and should not be set.

[terrypin]

Thanks @CK76. So as a novice I guess my safest approach is to never use Set which is what I see in most code?

Also, what do you call the command "dte = .....", if not 'setting dte'?

Must admit I'm confused that you can't set a value? I thought that was the common use?

[MrShorty]

Also, what do you call the command "dte = .....", if not 'setting dte'?

With normal "value" (not object) variables, it is called a "Let" statement: https://docs.microsoft.com/en-us/off.../let-statement Note that, except for some of the earliest iterations of the BASIC, the Let keyword has long been optional, and most programmers omit the Let keyword. So, "Let a=2" and "a=2" are equivalent. As has already been noted, the Set statement is required and is used when assigning objects to an appropriate object variable.

Even though explicit use of the Let keyword is rare, if it helps you as the programmer keep track of when you are working with normal variable types and object variable types, I see no reason why you could not also include the Let keyword in your programming.

Please Login or Register  to view this content.

[CK76]

So as a novice I guess my safest approach is to never use Set which is what I see in most code?

Not quite. Objects must be Set without exception, and as MrShorty noted, you can Let non-object variables (values).

It's bit hard to explain what/when to use Set, but you can find lists and explanation in below link. Worksheet, Range, Shapes etc are objects and need to be Set.
https://docs.microsoft.com/en-us/off...l/object-model

EDIT: You may find below article easier to follow.
https://excelmacromastery.com/vba-objects/

[terrypin]

Thanks both, understood in general, although I clearly need to study further as suggested. Not exactly intuitive - but then I suppose that’s true of any programming language! Well, maybe since FORTRAN and BASIC?