Finding Last occupied row

[j_Southern]

I have puzzling situation that I would like some help with
I have a large worksheet which is being added to. The addition is a column of names and a years dates. In the attached workbook the list of names is shorter and only a few dates have been added.
I know that the last record appears in a column that I can identify. I want to identify the range that has been added and apply various borderlines to it.
This is the code I use.

Please Login or Register  to view this content.

Startplace is the column number of the column to start the new matrix
YearLen is either 365 or 366
lrow is the last row of the matrix area. It is found in the column which precedes StartPlace.
MakeMatrix is the procedure that provides the border lines.

My problem is that code above does not work. It will sometimes work as I step through the code, but if I run the code it always says that lrow = 0
The much reduced sample I produced for the attached workbook always works, though.
The only difference between the actual and the sample is that ROW 9 to the left of the start of the new area consists of 12 monthly merged groups of cells.
I am completely flummoxed and badly need some guidance
John

[j_Southern]

It has just occurred to me that the procedure must be looking at the wrong column. Is there a way I could find if that is true?

[SyracuseWolvrine]

Could you just find the lastrow using something like this, and then work from there? This will check Column A, but can be (very) easily modified to look at a different column instead.

Please Login or Register  to view this content.

[Bo_Ry]

Try this

Please Login or Register  to view this content.

[rorya]

if I run the code it always says that lrow = 0

That shouldn't be possible with that code. The minimum value for lrow (assuming the line that assigns it has actually run) should be 1, even if you were looking at a blank column.

[Rick Rothstein]

This line of code will find the last row with data no matter what column it is located in...

Please Login or Register  to view this content.