View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Positioning the Calendar on working screen

Hi MVM,

Look at the VisibleRange Property in VBA help.

'=============
Public Sub Tester()
Dim rng As Range

Set rng = ActiveWindow.VisibleRange

With rng
Debug.Print .Top, .Left, .Width, .Height
End With

End Sub
'<<=============


---
Regards,
Norman


"MVM" wrote in message
...
How to find the working screen top, left, width and height.
when I pop up the calendar it goes some times goes out of screen. This is
forcing the user to scroll the window.
I tried activewindow but it is not the working area.
Thanks for the help.
MVM