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:
Please Login or Register to view this content.
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!)
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.
@ 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.
Yeah, I don't want to create a new workbook. I want a screen split of the same worksheet. Boom bam.
Figured it out. Thanks.
Last edited by JBeaucaire; 09-17-2015 at 06:43 PM. Reason: Removed cute but inappropriate slang.
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks