You are reading a single comment by @NotThamesWater and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@NotThamesWater
I'm not sure what you're trying to do here.
The code in this post will save the sheet "Output" as a new workbook. You can name this whatever you like.
If you have a number of different sheets ,you just change the sheet name.
Alternatively you can have the sheet name populated by looping through a list (i.e. 1 - sheet "AAA", 2 - "sheet B" etc...) or just hard coded (i.e.. write it out in the code each time).
If you are trying to make a new sheet from a load of different columns, you would need to do the following (in pseudocode)
Identify the range to be copied (e.g. columns 1 to 20)
loop through the range
copy the column to a new sheet
save the new sheet as a new workbook
move on to the next column
The code for each step would pretty much be in that order
But, it depends on what you are trying to do