Help with VBA to VBS

[xcaliber13]

Hi all,
I have a vba script that will that data that is in the first column and place in rows. Example: data repeats every 6 rows vba macro convert every 6 rows to columns. I am trying to convert to vbs scripting. I have gotten it all the way to this piece of code:

vba code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I am getting this error: Object required: 'Rows' from the line objExcel.Cells(Rows.Count,J).End(xlUP).Offset(1,0)_

Any help coverting this part of the VBA code to VBS would be great! Thank you

[shg]

Please Login or Register  to view this content.