Conflict in assigning values to a cell from another cell
 

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

Conflict in assigning values to a cell from another cell
 

Try formatting B16 as General and see if you still get the type mismatch.

"joed" wrote:

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

Conflict in assigning values to a cell from another cell
 

Formatting as general did not do it. The watch window still displays the type
as Variant/String and it still throws the same mismatch error.
--
j.f.dolan


"JLGWhiz" wrote:

Try formatting B16 as General and see if you still get the type mismatch.

"joed" wrote:

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

Conflict in assigning values to a cell from another cell
 

I got around the problem by checking to see if B16 value is currently
non-numeric which the first time the sheet is opened and populted it is. If
it is non-numeric I set it's value to 0 (zero). That changes the type of
"B16" to variant/double which gets rid of the type mismatch problem.
--
j.f.dolan


"JLGWhiz" wrote:

Try formatting B16 as General and see if you still get the type mismatch.

"joed" wrote:

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