Identifying Beginning and Ending Rows in a Selected Range

  • Thread starter Thread starter JR_06062005
  • Start date Start date
J

JR_06062005

Is there a way in VB to identify the beginning and ending rows in a selected
range. The command below gives the address:

ActiveWindow.RangeSelection.Address

But what I want to do is to determine how many rows (and perhaps columns)
are in a selected range.
 
Maybe

Sub Macro2()

x = Selection.Rows.Count
y = Selection.Columns.Count
MsgBox x & " Rows. " & y & " Columns."

End Sub

Mike
 
Thanks. That did the trick.

Mike H said:
Maybe

Sub Macro2()

x = Selection.Rows.Count
y = Selection.Columns.Count
MsgBox x & " Rows. " & y & " Columns."

End Sub

Mike
Click to expand...
 
Back
Top