View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad K. Brad K. is offline
external usenet poster
 
Posts: 41
Default Error getting Row number

Hello.
I have the follow in part of a sub.


Private Sub Workbook_SheetSelectionChange
..
<code
RowNum = ActiveCell.Row
<code
..
End Sub

The problem is when I select multiple rows I either get error messages or
freeze Excel (2002 w/ XP).
How do I change this so that if multiple rows are selected only then only
the bottom row is looked at for naming my variable.
Thanks in advance,
Brad K