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.

It should work. you have anything else in the code.

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=26268