PDA

View Full Version : Solved: test selection for first and last row



Djblois
03-28-2008, 06:56 AM
If I manually highlighted a range, is there a way to test programatically what the first row selected and the last row selected is?

Bob Phillips
03-28-2008, 07:30 AM
Msgbox Selection.Cells(1,1).Row

MsgBox Selection(Selection.Count).Row

Djblois
03-28-2008, 08:57 AM
This worked perfect thank you