add row Excel vba

Question

Hi,
I have a .xlsx file on my computer. I need a vba to add 1 row in this file on onedrive business.

https://hublogistics-my.sharepoint.com/:x:/g/personal/angelo_malfitano_hublogistics_ch/ETSkB2Xjb-hAoHCZLL7xXU8BOHSM3c0NeIKn1pVgiirlvA?e=6frCB4

Thanks for support

Angelo

Answer 1

Use:

With Sheets("Foglio1").Range("A1")
.Offset(.CurrentRegion.Rows.Count, 0).Value = "Text for new row in column A"
End With