Macro doesn't fully work. Need help with rows

I have a macro that converts a set of data to a different sheet, then shuffles the data around. Once shuffled, it copies it to a new file. My only issue is that... for some reason, it only copies the first 10 rows of cells for one of the columns only. Everything else it does fine. Can you guys see where I'm going wrong on my macro?

Please Login or Register  to view this content.

Note: The rows of data I will have (not because of the macro) will alway be different. Sometimes i'll have 8 structures, or 37, or 22, etc... but due to the macro, the names of only 10 will appear.

Thanks Ernest. I dint know why that works but it does. Funny thing is that I recorded that macro instead of vba, so I dint know why it would have failed me then.

Originally Posted by judgeh59

The one statement RANGE("G11").select literally put the cursor there and that's why you only got 10 rows....recording a macro is a GREAT way to get things started...I still do it sometimes...but it doesn't always make it dynamic...if that make sense.....

do you mean H11? I checked the code I copied on my first post of the thread and I didn't find anything for "G11".