View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Worksheet change sub procedure

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.