Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of Range Property | Excel Programming | |||
VBA Range Property | Excel Programming | |||
range property of range object | Excel Programming | |||
Range Resize property | Excel Programming | |||
using a range with isnumber property | Excel Programming |