View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Robert is offline
external usenet poster
 
Posts: 113
Default In SelectionChange Make Last Rwo Dynamic

How can the end row be made dynamic as rows are inserted. I could name cell
A12001 as €œEND€ with the formula =ROW(A12000)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("GLOBAL").Rows("1:12000").Calculate
End Sub

Thank you.

--
Robert