Solved: Loops that write specific data to file

[mohanvijay]

Hmm, your code runs into runtime error at line 59:

Quote:
Run-time error '9':
Subscript out of range

this is because i forget to change the workbook name change the workbook name as "sample (1)" it will run

and i tested both codes, they run correctly