vendredi 10 février 2012

Excel Macro Tip

Hi All,

When I began writing macros in Excel 5.0 I didn't know how to find the last cell row, given a column...And that's useful, suppose you have a user form, and that you want to put the content of that userform on a sheet.So here's the tip: you just have to declare a long variable (you need this because on Excel 2003/2007 you have more than 32768 rows on a sheet).You can write it like this:

Dim lastRow as Long

LastRow=range("A65536").end(xlup).row

And that's it, folks!!!

Aucun commentaire:

Enregistrer un commentaire