PDA

View Full Version : Solved: Find final Row In Mearge TOP Cell



r_know
06-03-2012, 06:45 AM
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
06-03-2012, 03:36 PM
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

r_know
06-04-2012, 03:48 AM
Many Thanks, Perfect ways work - out!!!!
Thread Solved.

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

Bob Phillips
06-04-2012, 07:59 AM
Tread Tools at the top of the thread/posts.

r_know
06-04-2012, 07:49 PM
I can not find , thread tool?

Bob Phillips
06-05-2012, 01:07 AM
If you are using Chrome, that seems to cause a problem.

r_know
06-05-2012, 01:26 AM
I did Solved.

Thanks for your help!!!