Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to show the active cell after running a macro?
I have a macro that inserts rows and copies formulas on two worksheets, and then selects the first cell into which the user should begin to enter data. The problem is that even though the right cell is selected for the user, that cell is not necessarily visible on screen. (The screen may be showing rows 70 to 100, when the relevant row is actually 500.) Is there a way to "find" the active cell? To make it so that Excel has not only selected the active cell, but is actually showing it as well? -- shellshock ------------------------------------------------------------------------ shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935 View this thread: http://www.excelforum.com/showthread...hreadid=391978 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to show the active cell after running a macro?
You can have it scroll to the row where the active cell is ActiveWindow.ScrollRow = ActiveCell.Row HTH -- bhofsetz ------------------------------------------------------------------------ bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807 View this thread: http://www.excelforum.com/showthread...hreadid=391978 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to show the active cell after running a macro?
That's exactly what I needed! :) Thanks so much; I figured there had to be a way to scroll the window but I just didn't know how to do it. -- shellshock ------------------------------------------------------------------------ shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935 View this thread: http://www.excelforum.com/showthread...hreadid=391978 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Show Macro is Running | Excel Discussion (Misc queries) | |||
Don't show sheet switches when running macro | Excel Programming | |||
Only want color to show when cell is active | Excel Worksheet Functions | |||
show messagen when running a macro? | Excel Programming | |||
Active cell blinks for no reason while running inside of Citrix XP | Excel Worksheet Functions |