ok soI placed the right under

the Sub Test () For j=1 to 100 and i got this below


27 27 27 27 27 27
54 54 54 54 54 54
81 81 81 81 81 81
108 108 108 108 108 108
135 135 135 135 135 135
162 162 162 162 162 162
189 189 189 189 189 189
216 216 216 216 216 216
243 243 243 243 243 243
270 270 270 270 270 270
297 297 297 297 297 297
324 324 324 324 324 324
351 351 351 351 351 351
378 378 378 378 378 378
405 405 405 405 405 405
432 432 432 432 432 432
459 459 459 459 459 459
486 486 486 486 486 486
513 513 513 513 513 494
540 540 540 540 540 520
567 567 567 567 567 546
594 594 594 594 594 572
is this
showing the how many times each macro runs? this is on the blank sheet.S
o if I get it to run on my sheet with data will this be placed over my existing data and not just run my macros ?