This code needs to be modified in Microsoft Visual Basic in a .xlsm file:
'start looping
For i = sloop To 10000
'make code set to fill
scode = Sheets("Sheet2").Cells(1, 6) & vbLf & Sheets("Sheet2").Cells(2, 6) & vbLf
For j = Sheets("Sheet2").Cells(i, 7) To Sheets("Sheet2").Cells(i, 8)
scode = scode & Sheets("Sheet2").Cells(j, 6) & vbLf
Next j
What needs to be changed is to remove the looping and make the html code be pasted in one go instead of "by pieces". Currently it is set to "piece by piece pasting".
Please send me a PM and I will send you the file. It's not that complicated once you see what is needed.
For a vba specialist in excel this should be a piece of cake.
My budget is currently not more than $10 for this project. This should not take you more than 15-20mins if you're good enough.