Thread: Excel Macro to enter same text in comment box file's property box of 132 different files
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Kat[_8_] Kat[_8_] is offline
external usenet poster
  
Posts: 8
Default Excel Macro to enter same text in comment box file's property box of 132 different files
On May 9, 10:38 am, Jan Karel Pieterse
wrote:
Hi Kat,

Thanks so much for the help. But the macro errors out here.

What is the error?

Regards,

Jan Karel Pieterse
Excel MVPhttp://www.jkp-ads.com
Member of:
Professional Office Developer Associationwww.proofficedev.com

Here is where it errors out
ActiveWorkbook.Worksheets(wsName).PrintOut

Reply With QuoteReply With Quote