Hi Tom,

A much more likely scenario!

Thank you.

---
Regards,
Norman



"Tom Ogilvy" wrote in message
...
Try

Msgbox Target(1).Value

--
Regards,
Tom Ogilvy

"Grant" wrote in message
...
Type mismatch error for msgbox Target.value

-----Original Message-----
Grant,

The Target argument is indeed a range reference. What
exactly do
you mean when you say you can't "use it"?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Grant" wrote in
message
...
Hi there,

The following sub procedu
Private Sub Worksheet_Change(ByVal Target As Range)

Target does not appear to be a Range object. I can't
use
it like Target.value or iMyInteger = RcCell Is Target
or
anything that would require an Object type.

Any ideas?

Grant.


.