Looping Through Columns And Rows

Hey Guys,

This is my third day with VBA, so i am a complete Newbie and not surprisingly am having some trouble. I am trying to write a section of code that:

1. Loops through cells of a given range and searches for a value greater than 0.

2. If Value meets above condition then copy that value into another cell of a different sheet

3. Continue searching and copying cells until all values from that range have been found and copied

This Loop is also within a For Next Loop that goes row by row and copies other values into another sheet until it finds the last row where it will end

I have set up a MsgBox test to see what values the initial Loop (one searching for values)is finding and for the most part it seems to be working correctly and returning the right values but after some values it returns a blank box when it should be returning the next found value

I know it is not pretty , but hey third day. Any pointers, tips suggestions and criticisms are welcomed and appreciated. Do not need the answer just direction and some hints

Here is the Code:

Please Login or Register  to view this content.