Macro to Autofit a table in Word from Excel

Hello all,

I'm using a macro to copy a whole bunch of tables from Excel 2007 to Word and can't figure out how to autofit the tables to the page size once in word. The word vba command is selection.AutoFitBehavior (wdAutoFitWindow) but, I can't seem to use that command from excel. Any ideas?

Hi,

Rather than Selection property, try to specify the table (index or name) in your code :

Please Login or Register  to view this content.

Regards,
michel

Yeah, that's got me on the right track. Thanks, Michael!