- May 24, 2014
Especially as i is the “Bound Variable” and all other Loop Variables will be forced ( “coerced”?) in the loop workings to be of its Type regardless of how they may be dimensioned and used elsewhere in the code ………..Like I said, you need to declare i as Long, not Integer. …
The code looks a bit similar to ones I have done in threads.. If you are still having problems, maybe you can post some sample table showing the sort of data you have and importantly wot results you expect to get based on that data…
… If you are not sure how to do that some notes on ways to do it:-
. 1 If you can, try uploading this, https://onedrive.live.com/?cid=8cffd...CE27E813%21189 instructions here MrExcel HTML Maker . This free Excel add-In is good for screen shots here of spreadsheets. Then everyone can quickly see what is going on and follow the Thread easily.
. 2 Up left in the Thread editor is a table icon. Click that, create an appropriately sized table and fill it in. (To get this icon up in the Reply window you may need to click on the “Go Advanced” Button next to the Reply Button)
. 3 Supply us with example Excel files (Can of course be shortened, or made - up data in case any info is sensitive)
. For example send over this free thing: Box Net,
Remember to select Share after uploading and give us the link they provide.