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


And that's it, folks!!!


Posts les plus consultés de ce blog

How to encrypt to a url safe string...

How to delete many-to-many relationship in Entity Framework...

Html to Image...