Hi I have a table in sheet2 B2:AD37 which I enter a rota into. Each week the row sizes alter. What I’d like to is be able to have a macro that takes the table and resizes it to fit landscape in word ready to print. Is this possible.
Cheers
Dave
Hi I have a table in sheet2 B2:AD37 which I enter a rota into. Each week the row sizes alter. What I’d like to is be able to have a macro that takes the table and resizes it to fit landscape in word ready to print. Is this possible.
Cheers
Dave
Is there a reason why you can’t print it from Excel using scaling?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi only the fact the people I’m sending this too would be scared to use excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks