Hippie Hot Sauce - Latest answer on Nov 17, 2009 07:13PM
I'm trying to write a Macro so that I can use a command button to automatically export a range of cells from a variety of sheets in a workbook. I pretty much know how to select the ranges and everything. But I need some help with exporting the information to a totally separate workbook, or emailing the information. I want to use a command button (which I know how to set up) so that my students can click on the button to run the macro that will do this.
If someone could help I would appreciate it.
(I have Excel 2003)