SelectionChange event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody,
In a
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
statement the Target variable contains the VALUE of the target cell. I need
the row number of the target cell. How can I get it?
Stefi
 
Not sure what you're after because you didn't post your code but instea
of Target.Value try this....Target.Value & Target.Address.

hope this helps

Simo
 
Target is a reference to the cell selected (a range object). Value is the
default attribute/property if you just use the variable target (msgbox
Target, equivalent to msgbox Target.Value). If you want the row use
Target.Row, or for column, Target.column
 
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

Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Unload a Form using SelectionChange 5
Returned position address on protected sheet 7
How to retrieve the last selected cell before SelectionChange even 2
SelectionChange Event Glitch 1
Intersect needs fixing 7
Junp start my Select Case Macro 12
Need Syntax for "AND" to Evaluate 2 Cells 4

Back
Top