View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MBaars MBaars is offline
external usenet poster
 
Posts: 2
Default Testing for chart in a worksheet

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