Results 1 to 2 of 2

Thread: locating activecell within activewindow ? [RESOLVED]

  1. Mar 27th, 2005, 03:01 PM #1
    MJBNET
    MJBNET is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2001
    Location
    TZI Transition Date
    Posts
    272

    Resolved locating activecell within activewindow ? [RESOLVED]

    anyone have an idea how to scroll the activesheet so:
    ActiveCell.Top is at the top of ActiveWindow.UsableHeight ??
    Last edited by MJBNET; Mar 27th, 2005 at 06:18 PM. Reason: RESOLVED
    Reply With Quote Reply With Quote
  2. Mar 27th, 2005, 06:17 PM #2
    MJBNET
    MJBNET is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2001
    Location
    TZI Transition Date
    Posts
    272

    Re: locating activecell within activewindow ?

    ...i got it...even better...brings activecell to top/left of window
    VB Code:
    1. ActiveWindow.ScrollRow = ActiveCell.Row

    2.     ActiveWindow.ScrollColumn = ActiveCell.Column
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width