How to find the last entered cell in excel

[kcvinu]

Hi all,

How to find the last entered cell in excel ? I am using RangeRead function. I have tested it with $oWorkBook.ActiveSheet.Usedrange.Columns("F:F")

But it will give some empty cells with it. Each time last entered cell is varying. So i need to find it programatically. 

[Kyan]

_{See if this (VBA)}
 

Try this: right click the sheet tab, select View Code and paste in
 

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("D6:D35")) Is Nothing Then Exit Sub
    Application.EnableEvents=False
    Range("A1").Value = Target.Address(False, False)
    Application.EnableEvents=True
End Sub

The last changed cell will be displayed in A1.

 

[MikahS]

This topic could help you out: >link

[water]

Please check the wiki.

[kcvinu]

@Kyan, I don't know vba. 

@MikahS, Thanks for the link. 

@water, That wiki really helping. Thanks a lot.

[water]