Solved: Find final Row In Mearge TOP Cell

[r_know]

Dear All,

I have attached the excel sheet with Button 1 and 2.
In button 1 I have merged Cell at top therefore not showing the text I want to insert at bottom of row.
If avoided merge cell in button 2, then its works.

How it works then for Button 1 with Merge Cell to find final row?

[Bob Phillips]

[VBA]With Worksheets("Sheet1")

nextrow = .Cells(.Rows.Count, "F").End(xlUp).Row
nextrow = nextrow + .Cells(nextrow, "F").MergeArea.Rows.Count
.Cells(nextrow, "F") = "SumValue"
End With
[/VBA]

[r_know]

Many Thanks, Perfect ways work - out!!!!
Thread Solved.

(Note, How I can make Solved thread, just forgot!!!)

[Bob Phillips]

Tread Tools at the top of the thread/posts.

[r_know]

I can not find , thread tool?

[Bob Phillips]

If you are using Chrome, that seems to cause a problem.

[r_know]

I did Solved.

Thanks for your help!!!