View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_30_] Bill[_30_] is offline
external usenet poster
 
Posts: 89
Default Last Row of Selection

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