Roopher
Board Regular
- Joined
- Jul 8, 2008
- Messages
- 73
Hello All!
I have an Excel 2007 table, a listobject, on one worksheet; to be used as a template for other tables I intend to add on other worksheets. What is the best way to copy it over to another worksheet? When I did it as seen in the code Excel created (when recording a macro while doing it manually), the DatabodyRange of the 'copy' was set to 'Nothing'...?
Best regards,
I have an Excel 2007 table, a listobject, on one worksheet; to be used as a template for other tables I intend to add on other worksheets. What is the best way to copy it over to another worksheet? When I did it as seen in the code Excel created (when recording a macro while doing it manually), the DatabodyRange of the 'copy' was set to 'Nothing'...?
Best regards,