Exit For Loop on Error?

[uberathlete]

Hi everyone.

I have the following code which selects all constants from column 2 to 30, then cuts and pastes into column A:

Please Login or Register  to view this content.

However, when the code does selection.special on totally blank columns, an error is generated. Is there a way to modify it so that it exits the loop if that error occurs?

Any help would be much appreciated.

[Norie]

Add code that checks if the ccolumn is empty and of it is exit the loop.

Something like this perhaps.

Please Login or Register  to view this content.