how to avoid infinite loops ine excel vba ?

**meen2525** · 10-25-2011, 01:39 AM

Hiii alll,
I have a requirement where I should check all the USED cells of an entire column and find if the first 4 letters is PT50.If its not PT50 it must be colored.However my code is going in infinte loop

its processing all rows in the sheet.(those without data too).doesn stop.
HELPPPPPPPPPP

how to avoid this infinite loop

this is my code
.Pleeeeeeeeeeeeeese correct it .seekin yr guidance .

Please Login or Register  to view this content.

**JapanDave** · 10-25-2011, 02:06 AM

Have you got a sample workbook?

**royUK** · 10-25-2011, 02:22 AM

Something like this

Please Login or Register  to view this content.

**meen2525** · 10-25-2011, 02:32 AM

Hii RoyUk,
Still a problem but Thanks a lot for replying

. The infinite loop has stopped now :D yippee..
but the problem now is its higlighting the cells which STARTS with PT50. I want it other way round. Highlight the cells NOT STARTIN with PT50. wat to dooo ? plllleaaase help.Thaaaaaanks in advance.

**royUK** · 10-25-2011, 02:37 AM

If you study the code then you will learn. It;s not difficult to change

Please Login or Register  to view this content.

**meen2525** · 10-25-2011, 02:41 AM

Hiii,
I found a way to overcome it.But it colours all other blank cells too

. can we JUST color those cells NOT STARTING with PT50 ? any expert advice on this ?? Thaaaaanks in advance

Please find the code below i modified from yours.

Code:

Please Login or Register  to view this content.

**royUK** · 10-25-2011, 02:51 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**meen2525** · 10-25-2011, 03:02 AM

Hi,
really sorry

I did not find that option before. Have modified it now

so is there any way we can JUST color those cells NOT STARTING with PT50 ?

**royUK** · 10-25-2011, 03:02 AM

You've used Quote Tags not Code Tags

Please edit them & check this

Please Login or Register  to view this content.

**meen2525** · 10-26-2011, 07:44 AM

thanks a loooot RoyUk

helped me a lot.this thread is solved

but i dunno how to mark it .help this newbie out .

**royUK** · 10-26-2011, 07:46 AM

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**meen2525** · 10-26-2011, 07:46 AM

thank you

did the same

how to avoid infinite loops ine excel vba ?

LinkBack

Thread Tools

Rate This Thread

Display

how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Re: how to avoid infinite loops ine excel vba ?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions