Hello Patrick,

Since your explaination was cut off, I assume you wanted Rng to refe
to the 4th cell to the right of "A200". Without the SET statemen
preceding the variable, Excel interprets the Rng(1, 4) as an array. Th
type mismatch occurs because Excel thinks you are assigning the strin
"X" to an array that has not been delcared.

There are a couple of fixes...

1) Remove the statement Range("A200").Select and use the following I
statement.

If CheckBox1.Value = True Then
Range("A200").Offset.(0, 4) = "X"
End If

2) Use a SET statement instead of Range("A200").Select.

Set Rng = Range("A200")

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=54632