VBA to copy the column and paste as new row with merged cells
Hello world
I am trying to copy a column value and paste as a new row after each row as a merged cell. I have started my step towards this and managed to add a blank row after each row on specified sheet with range but need further on copying the column cell value and paste into each row.
Any help would be appreciated.
Thanks
Screenshot 2021-11-19 125846.pngScreenshot 2021-11-19 125846.png
Please Login or Register to view this content.
always troubles with inserting, you have to start from the row above as referencePlease Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Update: Thank you so much.
I am working on increasing the row height dynamically. I have an another sheet ("VariablSheet") with dictionary of what row height should be if the LEN characters of row exceeds certain value. How do I make this dynamic?
Screenshot 2021-11-25 171059.png
So far, I have the below:
Please Login or Register to view this content.
Last edited by hai_its_; 11-26-2021 at 05:40 AM.
difficult, depends also on the used fond (monospaced) and size !
Please Login or Register to view this content.
Last edited by bsalv; 11-26-2021 at 05:38 AM.
yeah thank you. Because, its a merged cell it does not do autofit hence I am looking to increase the row height depending on the characters of the merged cell. Example, if the merged cell Len characters is greater than 0 then adjust row height to 15, then if len characters is greater than 195 then adjust row height to 30 and so on. I have attached the screenshot hope it makes sense.
Last edited by hai_its_; 11-26-2021 at 06:33 AM.
30 characters per row ???
Please Login or Register to view this content.
Thank you, I understood your concept and was able to incorporate with my sheet and it works !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks