assign value

[MetLife]

Hi,

I just noticed something about assigning worksheet values to vba variables.

age1 = Worksheets("Inputs").Range("Age")

is the same as

age1 = Worksheets("Inputs").Range("Age").value

I guess if the .value is missing it uses the default? Doesn't it seem better to throw an error in this case?

Thanks

 

[RoryA]

Doesn't it seem better to throw an error in this case?

Maybe, but it doesn't.

 

[Peter_SSs]

I guess if the .value is missing it uses the default?

Correct

Doesn't it seem better to throw an error in this case?

Not to me. There are lots of things both in vba and worksheet formulas that have defaults. Although it might be clearer if everything had to be specified, it would be much more cumbersome & time-consuming.

 

[MetLife]

Thanks for the explanations!