Range 's top property
 

Hi all,

what is range's top property about and what is the unit?

Clara
--
thank you so much for your help

Range 's top property
 

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
--
Gary''s Student - gsnu200720

Range 's top property
 

Serously, the unit is in points
--
Gary''s Student - gsnu200720


"clara" wrote:

Hi all,

what is range's top property about and what is the unit?

Clara
--
thank you so much for your help

Range 's top property
 

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."



"clara" wrote:

Hi all,

what is range's top property about and what is the unit?

Clara
--
thank you so much for your help

Range 's top property
 

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.

"clara" wrote:

Hi all,

what is range's top property about and what is the unit?

Clara
--
thank you so much for your help