G
Guest
Hello,
I have a program that will allow me to input data on many sheets, in my
workbook, from various testing that I do in a our lab. The program has a
cmdbutton which executes a macro to generate an MSWord document. The macro
cycles through each sheet in the activeworkbook and pulls data from cells and
writes it to the Word application. As the macro cycles through each sheet I
want it to check if there's a chart on that sheet and if so select and copy
it to the Word document. Is that possible somewhere in VBA??
Thanks,
Matt
I have a program that will allow me to input data on many sheets, in my
workbook, from various testing that I do in a our lab. The program has a
cmdbutton which executes a macro to generate an MSWord document. The macro
cycles through each sheet in the activeworkbook and pulls data from cells and
writes it to the Word application. As the macro cycles through each sheet I
want it to check if there's a chart on that sheet and if so select and copy
it to the Word document. Is that possible somewhere in VBA??
Thanks,
Matt