The event handling in VB can be very useful if You instead of a reference want an exact copy of the first cell to appear in the second cell.
On Sun, 2 Sep 2001 05:11:31 +0100, Mick Fitzpatrick <[log in to unmask]> wrote:
>Hello
>
>I use Excel 97. I'm working on a spread sheet where data (words and figures)
>are repeated in other cells.
>
>For example: a single word appears in cell A1 ... I need to have the exact
>same word in cell A10
>
>I know this can be achieved by copy/paste but I was wondering if it can be
>automated so that data is entered/updated in the second cell as it's
>inputted into the first?
>
>I hope I have made myself clear
>
>TIA ... Mick
>
> "Hold No Punches.." Rode brings you great shareware/freeware
> programs with his honest opinions in this weekly column.
> http://freepctech.com/rode
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
|