runtime error- For Next loop

[Pasha81]

Please Login or Register  to view this content.

Hi guys
Thats the code I have. Basically if any cell in Column AG has a value of "#N/A" I want the code to exit the macro and show the message I wrote "New contract detected........"

I thought my for-next statement looked fine but it doesnt work

any idea how I can make an adjustment? Also I need the macro to stop if an "#N/A" value is detected

thanks

[Pasha81]

I'm asking for it to exit the macro if 'N/A' is detected because this is just the beginnning of the code, there's more after that which will be carried out only if no 'N/A' values are detected in column AG

[shg]

Try this:

Please Login or Register  to view this content.

Please edit your post and change the PHP tags to CODE tags.

[Pasha81]

Thanks shg, that works...

I'll mark this as solved

However when i enter it into my larger code, it enters a row of "#N/A" values instead of leaving it blank, I'll post a new thread with aworkbook

Thanks again

[shg]

Pasha, not QUOTE tags, not PHP tags, CODE tags.

[Pasha81]

sorry, I found it now on the advanced options

thanks