Adding "All Borders" with a User Form (Similar to Data Form)

I was hoping to add this function to my user form. I know that the Excel pre-built Data Form can copy down cell formatting, including cell borders, when inserting a new row (if everything is wrapped in all borders, the new line will have all borders as well). I would like to add that sort of feature to my User Form. I have seen coding that is supposed to add borders to used cells, etc., but I can't seem to get anything to work. I have attached the coding of my User Form as a reference, but I am not sure how much help that will be.

Please Login or Register  to view this content.

Not tested.

Please Login or Register  to view this content.

It gave me the following error
"Compile Error: Invalid or unqualified Reference"

and highlighted
.Range
from

Please Login or Register  to view this content.

Works like a charm!

One last question, is there a way to extend the borders to the other filled cells in the row without overwritting the formula's in those cells? I guess I could include the formulas into the vba and have it write everything, but i am not very good with that.

I have information in Cells A:O, but only fill B:H with the User Form.

Any thoughts?