show active cell

  • Thread starter Thread starter dallas
  • Start date Start date
D

dallas

Hi

I want to show the contents i the active cell in another cell, fo
example cell A1.
Also when i change active cell.


dalla
 
Hi,

Not sure what you mean exactly. But if you want B1 to always show wha
A1 has, in B1 type ...

=A1

Is that what you're looking for
 
One way:

Put this in the worksheet code module (right-click the worksheet tab and
choose View Code):

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

Example..

If cell H14 is the active cell and the contents in H14 is "5"
then i want A1=H14 ("5")

If cell G32 is the active cell and the contents in G32 is "789"
then i want A1=G32 ("789")

and so on.....


dalla
 
Back
Top