Finding the last row with data in it, among multiple columns

[RedSummer]

Hey guys,
I'm trying to figure out the best way to do this.
I know how to find the last row used for a single column so I was attempting to find that value for all 13 columns, and then see which one was the largest and use that one.
In another language this code wouldn't be too difficult but I don't understand the syntax of VBA yet or know if there are better ways to do what i'm attempting.

Help is much appreciated, below is the scratch work of my code.
Thanks a ton
Red

Please Login or Register  to view this content.

[protonLeah]

Try this:

Please Login or Register  to view this content.

The line:
WorksheetFunction.Max(last(0), last(1), last(2), last(3), last(4), last(5), last(6), last(7), last(8), last(9), last(10), last(11), last(12), last(13))

must be:
RowCount = WorksheetFunction.Max(last(0), last(1), last(2), last(3), last(4), last(5), last(6), last(7), last(8), last(9), last(10), last(11), last(12), last(13))

I.e., you must assign the max value to a variable.

[mehmetcik]

Please Login or Register  to view this content.