kemperohlmeyer
Board Regular
- Joined
- Oct 4, 2006
- Messages
- 73
1) How do i tell vba to cycle through sheets in a workbook? Essentially i need a macro to run through each sheet, export as html (i know that part) and then go to the next sheet and repeat.
2) Each of the aforementioned sheets is very wide (about 80-150 columns). When i export i need the first five columns on the left and then some random (and changing) columns in the middle. It is easy to view with a simple pane freeze, but i don't know how to translate that into an exported view.
Thanks in advance.
ko
2) Each of the aforementioned sheets is very wide (about 80-150 columns). When i export i need the first five columns on the left and then some random (and changing) columns in the middle. It is easy to view with a simple pane freeze, but i don't know how to translate that into an exported view.
Thanks in advance.
ko