View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
grant grant is offline
external usenet poster
 
Posts: 24
Default getting value of range problem

I am having no luck trying to get the value of the range
from the worksheet_change sub procedure.

Worksheet_Change(ByVal Target As Range).

I think that 'Target' is a range object so why can't I
just simply go:
msgbox Target.value ?

Cheers for any help,
Grant.