can't figure out why this code crashes

First 2 lines are a problem

Please Login or Register  to view this content.

Boards rules ask you use 'Code Tags' when posting code - See item #3 on this page: http://www.excelforum.com/forum-rule...rum-rules.html

can you elaborate?

You can 't have 2 procedure declarations like that. You must finish one (End Sub) before starting another.

Please read the board rules

Originally Posted by bd3161

Crashes everytime I run it, not sure why. To me it looks good but not to excel.

After looking at your code I noticed some errors, I deleted this lines:

Please Login or Register  to view this content.

Try this code:

Please Login or Register  to view this content.

thanks for your help. Tried your suggestion and unfortunately, it don't work correctly. the cursor just runs to B26. It is suppose to wait on the first A cell for a change and then advance to the first B cell, wait for change and then paste that value to the A cell, then advance to next B cell, 60 times

bd3161, try to explain me better what you want the code to do...

well it was suppose to put a value in cell A20 and then set the active cell to B20 when a value is put in B20 then active cell moves to B21, when value put in B21 then active cell moves to b22, etc, etc. 60 times all changes of the active cell triggered by event change. I should note that before it moves a routine on a different machine takes place. what I am doin is weighing things on a scale so the trigger event is the number coming back from the scale