When I copy a table I have created either further down on the same sheet or onto a new sheet the row heights I have set dont copy over. Is there any way you can make them copy and paste as having to change them everytime is anoying
Thanks in advance
When I copy a table I have created either further down on the same sheet or onto a new sheet the row heights I have set dont copy over. Is there any way you can make them copy and paste as having to change them everytime is anoying
Thanks in advance
Hi Mark,
Since all cells in a row must by definition have the same height you need to select and copy the rows which contain the table and then paste special formats in column A.
Otherwise you would need a VBA macro to read the row heights of the rows which contain your table and then adjust the destination row heights.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks Richard
burnsy180,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks