I have tried ie: RL = Range("X1").Left
it seems Left pos of a range is toward ActiveWindo.Left not the screen
but it doesn't the same way like Userform1.Left

Please hepl me...

Hi Halim,

See the suggestions fro KeepITcool in the following thread:

http://tinyurl.com/lalbq

---
Regards,
Norman



"Halim" wrote in message
...
I have tried ie: RL = Range("X1").Left
it seems Left pos of a range is toward ActiveWindo.Left not the screen
but it doesn't the same way like Userform1.Left

Please hepl me...

Halim,
Depending what you are trying to achieve, you have:
Application.Left 'Measured in points
ActiveCell.Left 'Measured in points
Window.PointsToScreenPixelsX
Window.PointsToScreenPixelsY

NickHK

"Halim" wrote in message
...
I have tried ie: RL = Range("X1").Left
it seems Left pos of a range is toward ActiveWindo.Left not the screen
but it doesn't the same way like Userform1.Left

Please hepl me...

Hi Jones,

I've tried way similiar to KeepITcool way that I've create, but
it seems if in ActiveWindow.zoom = 90 they will work and not in other
zooming value, so I have to create a zooming factor based 90% zoom.

Any way I know that scroll horz/vertical is a factor too...

But I need the corect way.. so I can place Userform1.left right to
selection.left too and so on the top.

I think we need to know the class of Range in Excel as a childwindow of
XLMAIN or something .... :)

Ok, Lets find it ....

Thank you very much for sugestion and advance ... ...

If you have a new way please reply this...

Regards,

Halim



"Norman Jones" wrote:

Hi Halim,

See the suggestions fro KeepITcool in the following thread:

http://tinyurl.com/lalbq

---
Regards,
Norman



"Halim" wrote in message
...
I have tried ie: RL = Range("X1").Left
it seems Left pos of a range is toward ActiveWindo.Left not the screen
but it doesn't the same way like Userform1.Left

Please hepl me...

Hi Halim,

I've tried way similiar to KeepITcool way that I've create, but
it seems if in ActiveWindow.zoom = 90 they will work and not in other
zooming value, so I have to create a zooming factor based 90% zoom.

See posts #6 - #9 in the suggested thread, noting particularly RAF's
contribution in post #8


---
Regards,
Norman

Hi Norman,

Thank you very much for ur sug'tion, I apprecitd that.

<Smile

Regards,

Halim

Norman Jones menuliskan:
Hi Halim,

I've tried way similiar to KeepITcool way that I've create, but
it seems if in ActiveWindow.zoom = 90 they will work and not in other
zooming value, so I have to create a zooming factor based 90% zoom.

See posts #6 - #9 in the suggested thread, noting particularly RAF's
contribution in post #8


---
Regards,
Norman