Hello. I'm giving a presentation and I want to create a little macro button below a cell that splits the screen and then in the TOP SCREEN, goes to cell A40. Thanks.
Hello. I'm giving a presentation and I want to create a little macro button below a cell that splits the screen and then in the TOP SCREEN, goes to cell A40. Thanks.
so how should the division of the screen split be? Do you just want to see your sheet in half, or two different sheets or... ?
if the same sheet, what's the 'middle' for you? I assume it's not row 500,000 ;-)
Try this:
Sub Excelforum() Dim h&, w&, t&, w1 As Workbook, w2 As Workbook h = ActiveWindow.Height w = ActiveWindow.Width t = ActiveWindow.Top Set w1 = ThisWorkbook w1.Activate With ActiveWindow .WindowState = xlNormal .Top = t .Height = h / 2 .Width = w .Left = -5.75 End With Set w2 = Workbooks.Add w2.Activate With ActiveWindow .WindowState = xlNormal .Top = t + (h / 2) .Height = h / 2 .Width = w .Left = -5.75 End With w1.Activate ActiveSheet.Range("A40").Activate End Sub
Please click the * below if this helps
Ammartino44, did this posted solution work for you? Please respond and CLOSE this thread when done.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
@ jasper. That sorts of works but you are just doing copy new. I want to use the split screen window function. And the screen would split at row 80. Thanks.
Figured it out. Thanks.
Last edited by JBeaucaire; 09-17-2015 at 06:43 PM. Reason: Removed cute but inappropriate slang.
Sub boom() Worksheets("Sheet1").Activate With ActiveWindow .SplitColumn = 6 .SplitRow = 23 Range("A5").Select End With End Sub
Last edited by JBeaucaire; 09-17-2015 at 06:44 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Sorry big Beau. I'm catching up on my posts. I quickly read through them and then give feedback mas tarde. THis is how we do.
Yeah, I don't want to create a new workbook. I want a screen split of the same worksheet. Boom bam.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks