ending program

[justinjames92]

i have a program that moves values around the spread sheet randomly
the problem is when it gets to column a and tries to move left it stops the program and i have an error message what do i use to make the program end there and restart instead

 

[stnkynts]

Depends on how you are "moving" values around the worksheet. Are you using a loop in VBA? Could you incorporate a column check for if Column = A then Exit Sub?

 

[Ruddles]

You're asking us how to modify your code but without seeing it we're going to struggle.

Generally, any loops you use should be limited to the actual range of cells which have been used and any variable column or row references should be checked for sensible values before they're used.