VB output to excel

I have a script that i found on here somewhere that creates excel reports and imports all the data in rows. I would like for the data to be imported in columns. I tried it by changing all the row commands to column and all column commands to row, but with no success. What am i doing wrong?

Also, what did the Let and Set assignment statements change to or what they have been replaced with?

Thanks

Parents

AndersI over 6 years ago

As InspectorJester says, swap the rows and columns in xlSheet.Cells( RCount,CCount) to xlSheet.Cells( CCount,RCount) and any xlSheet.Range(" B1") to xlSheet.Range(" A2") (the letter B becomes the number 2, the number 1 becomes the letter A, and they swap place).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

AndersI over 6 years ago

As InspectorJester says, swap the rows and columns in xlSheet.Cells( RCount,CCount) to xlSheet.Cells( CCount,RCount) and any xlSheet.Range(" B1") to xlSheet.Range(" A2") (the letter B becomes the number 2, the number 1 becomes the letter A, and they swap place).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data