Excel: Recreating a Sheet with a Macro? -
I am looking for a simpler way to reproduce a relatively complex Excel sheet with a macro, cell values, Formulas, formatting, and cell size.
Actually, I have an Excel sheet and I need VB code which will create a sheet. To wit. Some macros prefer to use the recorder, but do all the steps in order.
Any thoughts?
(It would be more convenient to copy from template XL, of course, but I am limited to code and can no longer use additional files for production).
If you do not want to use additional files, then your template will have a different sheet in the same XLS Keep where your macro resides. IMHO, you should avoid reproducing a full letter by code for at least maintenance reasons.
Comments
Post a Comment