Excel programming question

[imranjiwani]

Hi

I have a simple question, why in the following line the variable is not assigned the value directly like this:
source_date = b8 instead of the following:

source_date = Range("b8").Value

Thanks for your help.

 

[RoryA]

Welcome to the forum.

The answer is simply that b8 has no meaning in VBA. It only works as an address passed to the Range property.