Code for Last row auto fit

[papasmurfuo9]

Hi team,


please could someone tell me how to write the following,

i have a spreadsheet, that has a macro that populates a row with data,

i want to highlight the last row with data, and autofit - please could someone tell me how to write this.


thank you.