Last row

[ehcpieterse]

Hi,

I am using the command: lastrow = ActiveSheet.UsedRange.Rows.Count

However, it returns a value of say 35, when I can clearly see that the last row I've used is 3. The command has always worked fine, but is returning these incorrect values lately.

Does anyone know why this is?

 

[xld]

UsedRange can hold previous values, it is a known bug.

Try using

LastRow = cells(Rows.Count,"A").End(xlUp).Row

change "A" to your key column.

 

[Andrew Poulsom]

Probably some cell in row 35 is formatted as other than the Normal style.

 

[ehcpieterse]

Thanks! works like a charm