How to set range and define rows/columns in this code

Can someone please explain to me how to define my rows/columns in this code? I want to set a range such as A through D and rows 1 through 10, for example.

Please Login or Register  to view this content.

Hi rim,

Try something like:

Please Login or Register  to view this content.

Lewis

Lewis, I guess I should have included the entire code. I tried what you suggested but I can't get it to work with this script. My script works but only exports Column "A"
Thanks

Please Login or Register  to view this content.

Hi Again,

I'm a little confused about what you're trying to do. The following is what it looks to me what you want. If I am wrong, it would be very helpful if you uploaded your input data Excel file, and uploaded your output HTML file.

Lewis

Please Login or Register  to view this content.

Originally Posted by LJMetzger

Hi Again,

I'm a little confused about what you're trying to do. The following is what it looks to me what you want. If I am wrong, it would be very helpful if you uploaded your input data Excel file, and uploaded your output HTML file.

Lewis,
Thanks for replying. I have attached an example file of what I am trying to accomplish. As you will see the file that is exported only contains the "A" column but I am needing all columns to export. Don't forget to create a folder called 'Files' at the same level as the spreadsheet. Thanks.

Try this (untested):

Please Login or Register  to view this content.

rimshot,

Try my code with your file. Your sample input file is the same (similar to) the test file I used. If my code doesn't work, please upload a sample output file.

Lewis