Pick constant value from cell value.

[motilulla]

Hello,

In the VBA below line I changed as follow to pick the value "3" from the cell value, but it does not work. Please could someone take a look and suggest how to correct it.

This one
Const v& = 3

Changed to this one
Const v& = Range("A3").Value

Thank you all.

I am using Excel 2000

Regards,
Moti

 

[FormR]

Hi, constants, as the name suggests, have to be constant - you need to declare it as a variable instead.

Dim v&
v = Range("A3").Value

 

[motilulla]

Hi, constants, as the name suggests, have to be constant - you need to declare it as a variable instead.

Dim v&
v = Range("A3").Value

FormR, yes it worked ideal! Thank you for your help

Good Luck!

Kind Regards,
Moti