getting value of range problem

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
Junp start my Select Case Macro 12
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Target Range Activation 11
Help with combining 2 seperate Worksheet Change Event scripts 2
Get Month name from Date value in cell 7
Combine Two Different Worksheet_Change codes 9
No response to change_event 4

Back
Top