Code for Last row auto fit

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.

Hi papasmurfuo9,

Suggest you to revise the thread title to reflect the query you are asking, see the forum rules:-


http://www.excelforum.com/forum-rule...rum-rules.html


Regards,
DILIPandey
<click on below * if this helps>