Range 's top property

  • Thread starter Thread starter Guest
  • Start date Start date
Sub ordinate()
x = Selection.Top
MsgBox (x)
End Sub

will measure how far the top of a range is from the top of the first row.

The unit is the name of a boring t.v. show
 
Here you go, Clara. Right out of VBA help file.

"The distance from the top edge of row 1 to the top edge of the range. If
the range is discontinuous, the first area is used. If the range is more than
one row high, the top (lowest numbered) row in the range is used. Read-only
Variant."
 
P.S. I believe the default measurement is in pixels, so you would need to
know your screen resolution setting to use the top property properly.
There's a tongue twister for you.
 
Back
Top