Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 2003 on an XP box
The following code snippet causes a mismatch error when it executes: Range("B16").Value = Target.Value + Range("B16").Value Now I have formatted "B16" to be of type Number, (and it is initially empty, the watch directory says it's value is "") Target is also formatted to be of type Number. I pasted Range("B16").Value into the watch window along with target.value The watch window says Range("B16").Value is of type Variant/String while target.value is of type Variant/Double, which I'm sure is why I get the mismatch error. I thought perhaps since Range("B16").Value is initially empty I could set it to 0 (zero) on start up of the worksheet. That did not fix the problem. Why is Range("B16").Value of type Variant/String ?? -- j.f.dolan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning cell values to variables | Excel Discussion (Misc queries) | |||
Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
Assigning cell values within a VBA program | Excel Programming |