Using Excel in word help needed.

C

Cerberus

I have done a copy and paste of an Excel workbook into Word and now would
like to write a VBA code that will reduce the height of the cells and put the
Word document into two columns. Once it is in two columns I need the second
column to start 9 spaces down. I even tried to record a macro and steal the
code, but I had issues making the cells reduce in height.

I changed the line spacing to 1.0 and changed the spacing after to 0 pts,
which helped but it still isn't enough. Does anyone know how to tighten up
the cells in Word or does this need to be handled in Excel somehow.

Thanks for any assistance in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top