Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2018, 05:04 PM
14spar15 14spar15 is offline Show same row on next sheet Windows XP Show same row on next sheet Office 2000
Advanced Beginner
Show same row on next sheet
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Show same row on next sheet


I am looking for a method so that if say row 450 is the 1st row showing underneath the header row and I changed to another sheet row 450 is again the 1st row showing underneath the header on that sheet. I am finding methods for determining the top row and methods for scrolling to particular row I can’t seem to tie the 2 together.
Reply With Quote
  #2  
Old 03-24-2018, 07:53 AM
NoSparks NoSparks is offline Show same row on next sheet Windows 7 64bit Show same row on next sheet Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Perhaps this in the 'another sheet' module ?

Code:
Private Sub Worksheet_Activate()
    Dim ws As Worksheet
    Dim visRng As String
    Dim ar, arr

Set ws = ActiveSheet

Application.ScreenUpdating = False

Sheets("Sheet1").Activate     '<~~~~~ change to suit
visRng = ActiveWindow.VisibleRange.Address

Application.EnableEvents = False
ws.Activate
Application.EnableEvents = True

ar = Split(visRng, ":")
arr = Split(Mid(ar(0), 2), "$")
ActiveWindow.ScrollRow = arr(UBound(arr))

Application.ScreenUpdating = True

End Sub
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show same row on next sheet How to copy excel sheet withe HEADER and Paste into new sheet? cloudforgiven Excel Programming 6 01-05-2017 07:30 PM
Show same row on next sheet Open an existing sheet by clicking on a cell in a master sheet darbybrown Excel 3 09-12-2016 05:12 PM
Find matching criterior in sheet 1 and copy to Sheet 2 Auto Excel Programming 3 03-19-2016 01:41 PM
Show same row on next sheet Want to show/hide mutiple grouped coloumns in Excel sheet with a button abutahir Excel 4 11-03-2015 01:07 PM
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft