View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default dtermine row/column boundaries of selected area

On Tue, 2 Jun 2009 09:30:01 -0700, Mike H
wrote:

Try

Sub Sonic()
FRow = Selection(1).Row
FCol = Selection(1).Column
LRow = FRow + Selection.Rows.Count - 1
LColumn = FCol + Selection.Columns.Count - 1



That looks cool too!

I learn so much in this group, I wish I had time to read every thread!


John Keith