Want Borders to stay after cut and keep the cell resizing option.

What I would really Love is if I can add data to the sheet via Copy/Paste from one workbook to this workbook/Sheet.

I would like to be able to cut rows and paste the row into the different sections for data integrity.

It would be great if the macro or any type of script would do the auto resize of cells. I have this code however it will not allow Undo function, if there is any option to get this functionality of cell resizing while keeping the undo available that would be awesome! here is the code:

Please Login or Register  to view this content.

I use that code because in column H "notes" there can be a bunch of text in there and would like the cell size to auto adjust.

Last but not least I would like the Row Height to remain at 18.8 after cut. Right now when a row gets cut it leaves behind a 15 height row.

I sincerely appreciate any assistance, thank you so much!

Ok, Thank you for the information TMS