last blank cell - row & column.

[dcmb]

Hi all,

sn     cust name      
1       james           
2       marry           
3       eunice      
4       john            
5       parry

when counting used rows, 5 will be returned, which is the last cell with data.

lastblankcell = ActiveSheet.UsedRange.Rows.Count

but when counting columns, 3 will return, which is the last blank cell. Why is it not 2?

lastblankcell = ActiveSheet.UsedRange.columns.Count

 

[dcmb]

It's alright. I found my answer. There's an cell in the last empty column that contains a space.