Hi i have started Writing a loop that will eventually copy the cells one by one depending on the if statement, i think that if i run it now, it should just do nothing even if the criteria is not met. But this does not happen, it just crashes excel instead.
Thats the loop
Please Login or Register to view this content.
thanks for the help
When you say crash do you mean crash or does the code raise an error?
Your loop is not updating anything other than the variable i
So the test of vCelli will never alter. If it passes first time it will just continue looping.
You need to update the variable references within the loop
Ok Thanks a lot that fixed my problem by re-wrting the variable inside the loop, and yes it was the whole prgram that crashed i presume it just got stuck then. Cheers for the Help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks