Hi Jacob,
Thanks for your help and sorry for late reply. I have problem as follow.
Let say I have data in A1 to A20 and first run of below code can place 20 in
cell A21. I pressed delete button or use ClearContents to clean up A21, next
run cursor stays in A22 and indicate 21 but I need the result always stay in
row A21 indicate 20.
Regards

LUsedRow = Application.Intersect(ActiveSheet.UsedRange,
Columns(1)).Rows.Count
Range("A" & LUsedRow + 1) = LUsedRow


"Jacob Skaria" wrote:

Try

Application.Intersect(Activesheet.Usedrange,Column s(1)).Rows.Count

--
Jacob


"Seeker" wrote:

Lost of threads here mentioned about how to get the last used row but I
couldnt find one about the last used row within a filtered range?
Say my used rows are from A1 to A20, row A20 may or may not show up after
filter, what is the code to get the 20 as variable?
Any idea please?
Regards