Tuesday, March 12, 2013

VBA - Retrieve Last Row From More Than One Column


Normally, its enough to know the last row in a specific column. In those cases I normally just use this widely method:

`Getting last row from column A

LastRow = Range("A" & Rows.Count).End(xlUp).row

But when you have several columns (for example 1 to 10) and you need to retrieve the last cell in use in any of these columns, we need something else.

1 comment:

Anonymous said...

The sands casino at the north sands casino in - SEGATICIN
The sands casino at the north งานออนไลน์ sands 샌즈카지노 casino is set 1 mile south of Portland and close to Portland's Emerald City 1xbet Marina and