Last Row of Selection
What is wrong with that way? You do't need rows(1), just
lastrow = selection.row+selection.rows.count-1
An alternative is
LastRow = rng(rng.Count).Row
--
HTH
Bob Phillips
"Bill" wrote in message
link.net...
Hello,
Is there a different way of getting the last row of a selection? The
first
row is selection.rows(1).row, but I can't get the last row without
counting
rows and subtracting one.
lastrow = selection.rows(1).row+selection.rows.count-1
Thanks.
Bill
|