Hi,

Enter a value in Sheet1 A1. The Worksheet_Change event will post the value to Sheet 2 (average run time of 1.5/100ths of a second).

To see the code right click on the Sheet 1 tab and choose View Code.

There is also a one line sub in module 1 for the button.

Cheers,

dr