"Set" command

[penfold1992]

Please Login or Register  to view this content.

Why is it that the first command doesnt require "Set" however the second one does. I have tried the "descend" without the word set but it doesnt work... so why does that require Set yet the first line doesnt?

thanks

[AB33]

You mean by first this one

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The first one is any varaible while the second is object varaible.
When you assign object varaible to an object, you need to use set

You could have used the full reference instead of with and with

Put this line in front of every line which has a dote infront and delete the "With and end with"

Please Login or Register  to view this content.

[TMS]

Because the first is "assigning" a value to a numeric variable and the second is "setting" the value of an *object* variable ... in this case, a range.

You probably don't really need the set here; you could just use:

Please Login or Register  to view this content.

But, if you use it elsewhere, it could make the code shorter and easier to read.

Regards, TMS

[penfold1992]

thanks for the responses. Objects are treated differently to numerical values =) got it.

[TMS]

You're welcome. Thanks for the rep.