Is there any way I can auto copy text from one cell to another without typing
it each time? I know how to use the function with numbers but when it comes
to the text Im lost. For exaple if I typed "TEXT" in cell A2 and wanted it to
repeat in cell A9, A15 and A17. If its possible Im looking to type it once
and have it automatically paste it into the cells I assigned.

Thanks in advance.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column < 1 Then Exit Sub
Cells(Target.Row, "b") = Target
Cells(Target.Row, "d") = Target
Cells(Target.Row, "g") = Target
Cells(Target.Row, "h") = Target
End Sub


--
Don Guillett
SalesAid Software

"Jessica" wrote in message
...
Is there any way I can auto copy text from one cell to another without
typing
it each time? I know how to use the function with numbers but when it
comes
to the text Im lost. For exaple if I typed "TEXT" in cell A2 and wanted it
to
repeat in cell A9, A15 and A17. If its possible Im looking to type it once
and have it automatically paste it into the cells I assigned.

Thanks in advance.

Jessica

In each of the cells A9, A15, A17 enter =A2


Gord Dibben MS Excel MVP

On Fri, 1 Dec 2006 09:22:01 -0800, Jessica
wrote:

Is there any way I can auto copy text from one cell to another without typing
it each time? I know how to use the function with numbers but when it comes
to the text Im lost. For exaple if I typed "TEXT" in cell A2 and wanted it to
repeat in cell A9, A15 and A17. If its possible Im looking to type it once
and have it automatically paste it into the cells I assigned.

Thanks in advance.