Excel 2003: workbook with 2 worksheets. Need to maintain values in
first sheet 3 first columns in sync with the 2nd worksheet 3 first
columns..

We initially used formulas on each cell in the 2nd worksheet to always
reference the values in the 1st sheet columns. However, there is no
limitation on rows that can be entered so we don't know how many rows
should we prefill with formulas. If we fill all the way down to the
limit of integer number row, file size becomes an issue.

We then switched to using a copy macro fired by a change event in the
spreadsheet. This works when values are typed, but not when pasted,
which we expect to be common usage.

So between not knowing how many rows to fill with formulas, and not
being able to respond to change event when pasting, we need another
alternative.

Thanks in advance.
VB

---

Request for Question Clarification by hammer-ga on 20 Apr 2006 07:22 PDT

Siam1,

Paste fires the Worksheet_Change event for me. Can you upload your
speadsheet to someplace we can get to it, so we can see what's going
on?

- Hammer

Not sure what the cause of your problem is. On my copy of Excel 2000
the Worksheet_Change() event is fired on pasting any of a single cell,
a range of cells, or plain text into the given worksheet, as well as
when typing into a cell. Perhaps someone else with Excel 2003 can tell
us if this is a version-specific thing or just something weird with
your system.

I would suggest an array formula instead. This formula type saves lots
of space with respect to the other.

I got the point what you r trying, but it would be lot more helpful to
solve this issue, if you could send us what is the exact job you are
trying to achieve, coz i have a solution for this if you can send us
the excel sheet in whixh u want to implement.