If Loop Wrong Usage?

**coconutmango** · 02-23-2011, 06:59 PM

I'm new to VBA, and was trying to write a simple loop code to check the value of a column of cells starting from B2 to B25 in sheet1 and if the value was greater than 0 it would go sheet2 and take the values starting in A1, multiple it by 3, and place the value in A2 and so forth. This would continue until all the cells in sheet1 were reviewed. For some reason this code will execute regardless of the value of the cells in B2 through B25. Cell B3 in sheet1 could have a -1 and yet the code will still execute. Any help would be appreciated.

Please Login or Register  to view this content.

**rylo** · 02-23-2011, 08:07 PM

Hi

The way your code is working (assuming that the typo is not in the real code), then if it finds 1 entry that is > 0, all the cells in the output sheet will be filled.

How about putting up an example file and show what should be the result from the data in that example file.

rylo

**stnkynts** · 02-23-2011, 08:11 PM

Im assuming that sheet 2 column A is going to be empty except for the first value, otherwise you are just going to be transposing over useless values. If they are emtpy this should work for you. If not we are going to have to change things.

Please Login or Register  to view this content.

On your code it might be better to use a counter inside the if statement rather than a loop in a loop. Up to you.

If Loop Wrong Usage?

LinkBack

Thread Tools

Rate This Thread

Display

If Loop Wrong Usage?

Re: If Loop Wrong Usage?

Re: If Loop Wrong Usage?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions