Maybe you didn't enable macros?

Maybe the Target was more than one cell?



lehigh46 wrote:

Hi All,

I have a sheet from Excel 2003 which has the code below written in the
"view code" in the sheet tab(s)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'Customize to the cell you want to act as the mirror
[B1] = Target.Value

End Sub

__________________________________________________ _____

I have since obtained a new computer with Excel 2007 installed.
It doesn't work in this new version.
Am I missing something?

thanks for any help you can give me.

Tom

--

Dave Peterson