Thread: bottom right cell on screen
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rocky McKinley Rocky McKinley is offline
external usenet poster
  
Posts: 102
Default bottom right cell on screen
'This will return the address of the visible cell in the bottom right hand
corner of the screen.
MsgBox
Range(ActiveWindow.VisibleRange.Address)(ActiveWin dow.VisibleRange.Count).Ad
dress

'or to select it ...
Range(ActiveWindow.VisibleRange.Address)(ActiveWin dow.VisibleRange.Count).se
lect

--
Regards,
Rocky McKinley


"Stuart" wrote in message
...
How can I get the bottom right cell that can be seen on the screen?




Reply With QuoteReply With Quote