ACTIVE CELL

[verluc]

How can I get the text from the active cell in A1.?
Example: I choose cell D10 and automatickly I get this text in A1?
Many thanks in advance.

 

[Andrew Poulsom]

Like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("A1").Value = ActiveCell.Value
End Sub

 

[JohnG]

in ThisWorkbook
enter

Private sub Worksheet_selectionChange
Range("A1").value=activecell.value
End Sub

Hope this helps

 

[verluc]

On 2002-10-21 08:50, Andrew Poulsom wrote:
Like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("A1").Value = ActiveCell.Value
End Sub

Many thanks Andrew
It works like I wanted.